Menu

combo box control source

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Nigel[_2_] Nigel[_2_] is offline

Nigel[_2_] is offline

external usenet poster

Posts: 735

Default

combo box control source

Oops! sorry misread row for control - but maybe that is what you want?

--

Regards,
Nigel

"Nigel" wrote in message
...
ComboBox1.RowSource = "MyRangeName"

or if named range is sheet specific

ComboBox1.RowSource = "Sheet1!MyRangeName"

--

Regards,
Nigel

"paula" wrote in message
...
I need to use a named range for the control source for a combo box in a
userform. is that possible, and if so, how!

thanks!
--
paulao

Reply With Quote

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
Syntax for control source in combo box control	dhstein	Excel Discussion (Misc queries)	1	August 12th 09 05:38 PM
Control Source / Row Source very unstable	Marc Gendron[_2_]	Excel Programming	1	November 28th 06 10:23 PM
"Combo Box - getting control combo box to stick in place in worksh	ajr	Excel Discussion (Misc queries)	1	February 16th 05 02:05 AM
"Combo Box - getting control combo box to stick in place in worksh	ajr	Excel Discussion (Misc queries)	0	February 15th 05 07:45 PM
Control Tab from Combo box- format control missing!!	Mo	Excel Discussion (Misc queries)	3	January 7th 05 01:09 PM

All times are GMT +1. The time now is 06:10 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement