using vba to change command button caption
 

I need to know how to use vba to change the caption in a command button on an
excel spreadsheet. Any assistance would be appreciated.

Paula

using vba to change command button caption
 

CommandButton1.Caption = "Your Text Here"

using vba to change command button caption
 

Assuming you know how to get to the code window, the code would be:

commandbutton1.caption = "xxxxxxxxx"

"PaulaO" wrote:

I need to know how to use vba to change the caption in a command button on an
excel spreadsheet. Any assistance would be appreciated.

Paula