View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How can the caption of a (button) shape (not cmd) be changed from VBA

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?