Can one combo box control the data in a different combo box
 

I though I saw a post on this some time ago but cannot find it. Is it
possible to have one combo box control the input range for another combo box?
What I would like to have set up is one box that has a list of my regions
and when a user selects one region the next combo box, for store#, will only
display the stores in that region.

Can one combo box control the data in a different combo box
 

i hope you see this.If you mean a forms toolbar combo the answer is yes,i use
a vookup formula to populate the combo box(es)
--
paul

remove nospam for email addy!



"MarkM" wrote:

I though I saw a post on this some time ago but cannot find it. Is it
possible to have one combo box control the input range for another combo box?
What I would like to have set up is one box that has a list of my regions
and when a user selects one region the next combo box, for store#, will only
display the stores in that region.

Can one combo box control the data in a different combo box
 

I am using a forms combo box. I do not understand how you get the second box
to use the results from a vlookup.

"paul" wrote:

i hope you see this.If you mean a forms toolbar combo the answer is yes,i use
a vookup formula to populate the combo box(es)
--
paul

remove nospam for email addy!



"MarkM" wrote:

I though I saw a post on this some time ago but cannot find it. Is it
possible to have one combo box control the input range for another combo box?
What I would like to have set up is one box that has a list of my regions
and when a user selects one region the next combo box, for store#, will only
display the stores in that region.

Can one combo box control the data in a different combo box
 

http://www.xldynamic.com/source/xld.Dropdowns.html


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=569917

Can one combo box control the data in a different combo box
 

what is your email address i will send you an example
--
paul

remove nospam for email addy!



"MarkM" wrote:

I am using a forms combo box. I do not understand how you get the second box
to use the results from a vlookup.

"paul" wrote:

i hope you see this.If you mean a forms toolbar combo the answer is yes,i use
a vookup formula to populate the combo box(es)
--
paul

remove nospam for email addy!



"MarkM" wrote:

I though I saw a post on this some time ago but cannot find it. Is it
possible to have one combo box control the input range for another combo box?
What I would like to have set up is one box that has a list of my regions
and when a user selects one region the next combo box, for store#, will only
display the stores in that region.

Can one combo box control the data in a different combo box
 

Mark
Haveyou figured this out as yet? Have a similar issue.

"MarkM" wrote:

Paul, I sent you an email.

"paul" wrote:

what is your email address i will send you an example
--
paul

remove nospam for email addy!



"MarkM" wrote:

I am using a forms combo box. I do not understand how you get the second box
to use the results from a vlookup.

"paul" wrote:

i hope you see this.If you mean a forms toolbar combo the answer is yes,i use
a vookup formula to populate the combo box(es)
--
paul

remove nospam for email addy!



"MarkM" wrote:

I though I saw a post on this some time ago but cannot find it. Is it
possible to have one combo box control the input range for another combo box?
What I would like to have set up is one box that has a list of my regions
and when a user selects one region the next combo box, for store#, will only
display the stores in that region.