Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to make the comments I add to cells in my worksheet appear when I
tab or click in a cell, as opposed to having to point with the mouse. For various reasons, data validation message boxes don't work (limitations in number of characters, etc.) Here is my code (I am NOT experienced in VBA, which you can tell). I keep getting errors. I want to say: In the active sheet (or workbook, or even range!) when I click or tab to a cell, display the comment. ub DisplayComments() If activecell.comment Is Nothing Then 'do nothing Else comment.Visible = True End If Thanks for your help! -- Thanks! Dee |