Posted to microsoft.public.excel.programming

John C.[_4_] John C.[_4_] is offline

external usenet poster

Posts: 5

Dropdown Rowsource

I have a list of items on Sheet1 that provide a dialog
dropdown with input values for selection.

I call this dialog while Sheet2 is active. The dropdown
looks in the cells referenced in 'rowsource' on the active
sheet, not sheet1 as desired.

Any way of specifying the sheet and range in the dropdown
rowsource property?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Using IF, Then with rowsource?	CAA[_23_]	Excel Programming	8	April 4th 04 08:56 PM
RowSource Problem	Todd Huttenstine[_2_]	Excel Programming	1	January 20th 04 04:09 AM
RowSource in ListBox	aet-inc[_2_]	Excel Programming	1	December 3rd 03 12:41 AM
Dropdown Rowsource	Aechelon[_7_]	Excel Programming	1	October 24th 03 11:48 PM
listbox rowsource	Christy[_2_]	Excel Programming	4	September 20th 03 11:44 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us