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

CommandButton1.Caption = "Your Text Here"

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