Change Control Toolbox Button Caption
Per
Thanks for your response but I don't have a UserForm. The button is a
simple Control Toolbox button on the sheet. Otto
"Per Jessen" wrote in message
...
Userform1.Commandbutton1.caption="New Caption"
Regards,
Per
"Otto Moehrbach" skrev i meddelelsen
...
Excel XP & Win XP
I have a Control Toolbox button, "CommandButton1" with a caption of, say,
"Old Caption".
I want to change the caption via VBA to, say, "New Caption".
How do I code that?
Thanks for your time. Otto
|