Referencing worksheet controls

[Frederick Chow]

Hi all,

Suppose I have a command button (cmdCommandButton1) in a worksheet named
"Sheet1". How can I refer to this control outside this sheet?

I tried this one but didn't work:

Worksheets("Sheet1").CommandButton1

Thanks for your advice.

Frederick Chow
Hong Kong.

 

[Kevin B]

Under Excel objects in the Project Explorer, select the sheet that has the
command button. You can then reference the button using the "Me" keyword.

If the button is named cmd1 Me.cmd1.Select would select the comman button.

 

[Frederick Chow]

Sorry, some misunderstanding...

What I meant really was if cmdCommandButton1 is located on sheets other than
"Sheet1".

Thanks for your advice in advance.

Frederick Chow