Change CommandButton Caption

[Claude]

Hi

Does anyone know how to change the text on a command
button? The following does not work:

ActiveSheet.Shapes("CommandButton1").Caption = "test"

 

[Chip Pearson]

Claude,

Try the following:

ActiveSheet.Buttons("Button 1").Caption = "test"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

ActiveSheet.OleObjects.("CommandButton1").Object.Caption = "test"

 

[Lisa Norgaard]

Hi

Does anyone know how to change the text on a command
button? The following does not work:

ActiveSheet.Shapes("CommandButton1").Caption = "test"

Try this:

ActiveSheet.CommandButton1.Caption = "test"

 

[Claude]

Hi Lisa

This one worked! Thanks

-----Original Message-----
"Claude" <[email protected]> wrote in

Try this:

ActiveSheet.CommandButton1.Caption = "test"
.