To display a message when mouse pointer over a button

[Sibilia]

Hi,

In VBA, how do you display a message(dialog box or comment) when your mouse cursor is over an object (button for example)?

for example: if I put my cursor over the "B" in the toolbar, it will displays "Bold".
I would like to know How I could do/progam that.


Thank you very much for your help

Sibilia

[Leith Ross]

Hello Sibilia,

If an object has a ToolTip property, set this to the message you want displayed. This option can also be hidden. So check your project by clicking Tools in the VBA Editor, Options and then select the General Tab. There is a checkbox that will hide or show the tool tips.

Hope this helps,
Leith Ross

[Sibilia]

Hi Leith,

Thank you very much for this help. For my understanding, it means that you can use the "tooltip" option only for objects insert in a toolbar. You can't do it for object floatting in your spreadsheet and not insert in a toolbar.
Is this right?

Thanks again

Sibilia