What is the name property of a command button on a worksheet

[seinon]

I've inserted a Command Button (activeX control) to a worksheet. I want to modify its caption using vba code. How do I determine the name property of the button so that I can refer to it in the code?

[Solus Rankin]

Please Login or Register  to view this content.

e/ In design mode, if you right click the button and go to properties it will show you the button's name.

[seinon]

Thanks! What about the same question, except wanting to use vba code to modify the caption of a Button (Form Control)?

[Solus Rankin]

Please Login or Register  to view this content.

The name of the button can be found in the name box (to the left of the formula bar) when the button is selected.

[seinon]

Thanks again!

I changed the Sheets("Sheet1") to ActiveSheet and it worked. When I tried it exactly as recommended, I got an error...

Run-time error '9':

Subscript out of range

Don't know why I got the error since the button is on Sheet1 - but oh well. It works now!