Control tip text
 

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.

Control tip text
 

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.

-----Original Message-----
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="tex t"
End Sub

But it does not work.

How to do it?
Many thanks.
.