Thread: Change CommandButton Caption
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Claude Claude is offline
external usenet poster
  
Posts: 36
Default Change CommandButton Caption
Hi Lisa

This one worked! Thanks

-----Original Message-----
"Claude" wrote in
message ...
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"
.

Reply With QuoteReply With Quote