Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text control won't expand | New Users to Excel | |||
Control Box Text Box | Excel Discussion (Misc queries) | |||
Bolding text in a control text box. | Excel Discussion (Misc queries) | |||
Text Control - Wrap Text | Excel Discussion (Misc queries) | |||
Limiting physical length of text in a text box control | Excel Discussion (Misc queries) |