Posted to microsoft.public.excel.programming

green[_2_] green[_2_] is offline

external usenet poster

Posts: 1

How do I get a reference to a control on a sheet?

I am using VBA in Excel XP and Win 2k

I have several drop down controls on a sheet. The control are NOT ActiveX objects.

How do I loop through all the controls on the sheet and set them all to list index 0 (the first choice)

Thanks.

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
Nesting a sheet name reference within a cell reference???	Broyston	Excel Discussion (Misc queries)	9	July 8th 08 08:35 PM
Changing sheet reference to cell reference	TeeJay	Excel Worksheet Functions	3	October 19th 07 11:50 AM
Control in Chart Sheet	Anderflash	Charts and Charting in Excel	6	June 7th 07 10:26 PM
Control Sheet	Cedrun	Excel Worksheet Functions	2	October 4th 06 09:48 PM
Syntax to return the value of a control by reference	Broadband Al	Excel Discussion (Misc queries)	3	January 26th 06 01:20 AM

All times are GMT +1. The time now is 03:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us