HLP - Make comment appear when click cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Comments work well for me, because I can resize them, etc., which I cannot
to with a text validation box.

However, I want to give some sort of worksheet or workbook instruction that
makes the comment appear when the cell is activated, as opposed to having to
take the mouse and hover over the comment to see it.

Help!
 
activecell.Comment.Visible=true
will show the comment in the activecell

You could use the selection_Change event to show & hide your commebts
 
Hi and thanks for the reponse.

I tried this, but when I hit Tab to go to the cell where I have a comment,
it doesn't display it.

My actual code is as follows. I placed the code in the Workbook, although I
tried in worksheet and also Module1. Am I doing something wrong?

Thanks!

Sub CommentsVisible()
'
' CommentsVisible Macro
' Macro recorded 5/08/2007 by Dee
'
ActiveCell.Comment.Visible = True

'
End Sub
 
Back
Top