Control tip text

[Perrier Shaw]

Hi,

I'd like to add control tip text to command buttons on a
worksheet.

I've tried to include the code :

Sub Workbook_open()
Sheets("test").commandbutton1.controltiptext="text"
End Sub

But it does not work.

How to do it?
Many thanks.

 

[Mike]

This property does not exist for Excel controls. It may
be available for Visual Basic, but Excel VBA is not the
same thing. Right-click your controls while in design
mode and select properties to see what you can use. If
you want to add a "tip" then use an Excel comment in the
cell closest to the control.