Comments
 

Hi all,

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

Thanx

Comments
 

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

Comments
 

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

Comments
 

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

Comments
 

"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

Comments
 

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