| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Button
Hi,
I just added a button to one of my worksheets this way: ActiveSheet.Buttons.Add(100, 300, 180, 15) Now I would like to change the caption of the button, but don't know how to do it. Help and MSDN-Reference don't cover this object or I cannot find it. I can add an event to my buttons, but cannot change the caption... ActiveSheet.Shapes(3).OnAction = "SwitchTo_" ActiveSheet.Shapes(3).Name = "Caption" ' doesn't work Any suggestions? Many thanks Alex |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change caption of a button | Excel Worksheet Functions | |||
| Toggle change control button face id & caption | Excel Programming | |||
| How to change Button Caption? | Excel Programming | |||
| Change caption on a macro button | Excel Worksheet Functions | |||
| Change Caption of Forms Command Button | Excel Programming | |||
Threaded Mode
