Posted to microsoft.public.excel.programming

RichardGarfield RichardGarfield is offline

external usenet poster

Posts: 6

Referring to current control on a worksheet

I need to be able to refer to the current commandbutton on a worksheet
without specifying the name each time - I have about 25 on each worksheet.

Is there a way of doing this? I have tried 'ActiveControl' but it seems not
to work on a worksheet.

Please can anyone help?

Richard

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
Referring to an ActiveX control	Brett	Excel Programming	4	May 17th 09 11:20 PM
referring to worksheet	Chip Pearson	Excel Programming	0	December 1st 06 11:42 PM
referring a worksheet	lazmanyak	Excel Worksheet Functions	1	July 23rd 05 02:55 PM
referring to other worksheet	Geetu M	Excel Worksheet Functions	2	March 29th 05 09:37 PM
Can I control Macro run automatically current worksheet?	Microlong	Excel Programming	2	March 2nd 05 12:39 PM

All times are GMT +1. The time now is 09:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us