View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Lisa Norgaard Lisa Norgaard is offline
external usenet poster
 
Posts: 2
Default Change CommandButton Caption

"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"