Change a buton "Caption" from VBA

[0000_AAAA_0000]

Hi!

and Many Thanks in Advance!


If i have a commandBoton; to change his caption
all I have to do is:

Sub AAA()
With ActiveSheet.CommandButton1
.Caption = "NewName"
End With
End Sub



but:

how can I change a Button name when is not a CommandBoton but a Buto
from the form Toolbar

 

[Ivan F Moala]

ActiveSheet.Shapes("Name of Button").TextFrame.Characters.Text
"Testing 123

 

[Tom Ogilvy]

Assume rather than change the button's name, I assume you mean you want to
change the caption (what is displayed on the button).

Activesheet.buttons("ButtonName").Caption = "ABCD"

would be another way (perhaps more direct).