Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If it is a button from the forms toolbar, it does have a caption property.
However, you have to treat it as a button to use it. If you want to treat it as a shape: ActiveSheet.Shapes("Button 1").TextFrame.Characters.Text = "ABCD" but as a button it is ActiveSheet.buttons("Button 1").Caption = "ABCDEF" A button is a hidden object in the object browser, so if you right click on the browser and select show hidden members, you will be able to see the properties. Unlike Jim, unless there are special properties you need to work with, I don't see any reason to go to control toobox toolbar commandbuttons. -- Regards, Tom Ogilvy "AnExpertNovice" wrote in message ... On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CURSOR SHAPE HAS CHANGED | Excel Discussion (Misc queries) | |||
Can Multiple Range Pivot Table's field button's caption be changed | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
Caption of a button | Excel Programming |