HLP - Make comment appear when click cell
 

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!
--
Thanks!

Dee

HLP - Make comment appear when click cell
 

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

You could use the selection_Change event to show & hide your commebts


"dee" wrote:

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!
--
Thanks!

Dee

HLP - Make comment appear when click cell
 

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


--
Thanks!

Dee


"Rob" wrote:

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

You could use the selection_Change event to show & hide your commebts


"dee" wrote:

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!
--
Thanks!

Dee