Control tip text

  • Thread starter Thread starter Perrier Shaw
  • Start date Start date
P

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enumerate buttons on user form 2
How can i Enable/Disable CommandButtons from Wkbook Open event ??? 1
simple question "disable command buttons" 1
ControlTipText 1
MouseMove & Click event over an image control 1
Excel VBA help: Text file formatting 19
HOW CAN I WRITE A CODE TO A COMMANDBUTTON CREATED PROGRAMMATICALLY 1
Problem with ActiveX control 1

Back
Top