Comment

Home Search Site Map

Up
Cells...
Chart...
Columns
Comment
Diagram...
Function...
Hyperlink...
Name
Object...
Page Break
Picture
Rows
Symbol...
Worksheet

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Comment  

Inserts a comment at the currently selected cell(s). Comments are electronic 'post-it' notes attached to cells.  They contain the name of the author by default and depending on the setting under Tools>Options...>View, will either, show as a small red indicator triangle in the upper right of the cell (default), the indicator and comment will show or nothing will show at all. If you have the default 'indicator' showing, the full comment will be shown as you move the mouse over the cell that contains it. Comments can be edited by either returning to this menu option when a commented cell is selected, (the option will have changed to Edit Comment) or right clicking on the cell and selecting Edit Comment. Comment boxes can be re-sized by dragging the 'sizing handles' (hold down the Alt key to size them exactly to cell heights and widths) and formatted with regard to text colour, font and style, (as below).

 Comments can be printed in-situ or at the end of a printout, by selecting the options in File>Page Set-up...>Sheet tab. Equally, I have some code which prints all comments in a workbook to a text file with the source address and comment and also copies comments across sheets.

VBA Sub AddComment()
'Check to see there isn't already a comment in A1
If Range("A1").Comment Is Nothing Then
'Adds a dated comment
Range("A1").AddComment Text:="This is a silly example. " & _
"Created on: " & Date
're-sizes the height of the comment box
Range("A1").Comment.Shape.Height = 30
End If
End Sub

Top

 

Copyright Nick Hodge 2008. All Rights Reserved.