Excel 97 Comment Display

  • Thread starter Thread starter Jon Lark
  • Start date Start date
J

Jon Lark

Is there a way to cause a comment associated with the
active cell only, to be visible, regardless of whether the
mouse pointer is "hovering" over the cell? As the
user "tabs" or "arrows" across the worksheet, I would like
the comment for the active cell to pop up, while comments
associated with the inactive cells remain invisible.
 
One way:

Put this in the worksheet code module (right-click the worksheet
tab, choose View code and paste the sub into the window that opens):

Private Sub Worksheet_SelectionChange( _
ByVal Target As Excel.Range)
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
On Error Resume Next
ActiveCell.Comment.Visible = True
On Error GoTo 0
End Sub

Note: You'll still be able to read comments by hovering over the
cells with the cursor.
 
I assume you just want to shwo the message (vs editing input);

Data->Validation
Ensure the "Settings" = "Any Value"
"Input Message" = Set to whatever you want (allows for a heading and
message)
Select "Show input message..."
"Error Alert" = de-select the "Show Error..."


--
Regards;
Rob

Please reply to the NG, I'm already up to my eyeballs in Nigerian/South
African get rich letters
as well as "Microsoft Critical Updates" et al.
 
Back
Top