Posted to microsoft.public.excel.programming

Frederick Chow Frederick Chow is offline

external usenet poster

Posts: 75

Referencing worksheet controls

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Controls in a Worksheet	Jeff	Excel Programming	4	July 11th 05 11:59 PM
Controls on worksheet	gr8guy	Excel Programming	1	May 1st 04 03:11 AM
controls on worksheet	jim c.	Excel Programming	3	February 9th 04 06:43 PM
Worksheet Controls	Andrew Arthur	Excel Programming	0	February 5th 04 06:46 PM
Referencing to controls on a worksheet	John Nikolopoulos	Excel Programming	3	September 10th 03 10:08 AM

All times are GMT +1. The time now is 02:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us