Hi all,

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

Thanx

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

HTH. Best wishes Harald

"Hatzipavlis Stratos" skrev i melding
...
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" skrev i melding
...
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

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" wrote in message
...
Hi all,

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

Thanx

Thank you guys


"Hatzipavlis Stratos" wrote in message
...
Hi all,

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

Thanx

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.

"Hatzipavlis Stratos" wrote:

Thank you guys


"Hatzipavlis Stratos" wrote in message
...
Hi all,

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

Thanx