Comments

[Hatzipavlis Stratos]

Hi all,

How can i make a comment appear by just placing the mouse cursor over a
button but without pressing it?

Thanx

 

[Harald Staff]

Tools > Options, View tab, there's a "Comments" section. Check "comment
indicator only".

HTH. Best wishes Harald

 

[Bob Umlas]

If you have an ActiveX button (from the control toolbox), you can display
something with the mouseMove event:
Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
'code here, like an existing textbox which has been made invisible (via
initialization code (like workbook_open or SheetActivate) of some sort) is
made visible
End Sub
but the real problem is that there's no way to make it go away since there's
no MouseNotOver event.
You can do this when in a userform, since there, you have the mousemove
event of the form itself to make the comment disappear.

 

[Hatzipavlis Stratos]

Thank you guys

 

[Harald Staff]

Tools > Options, View tab, there's a "Comments" section. Check "comment
indicator only".

Oops. You said Button, I read Cell. Sorry.
What you want is the ToolTipText property used in Visual Basic and other
programming languages. The controls in Office VBA does unfortunately not
support that.

Best wishes Harald

 

[Guest]

I am not so sure what kind of "comment " that u want , tooltip near the
button or description at the left-hand bottom ? I thought the tooltip near
the button is always there already.