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

[MarkM]

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.

[paul]

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
[email protected]
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.

[MarkM]

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
> [email protected]
> 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.

[DCSwearingen]

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

[paul]

what is your email address i will send you an example
--
paul
[email protected]
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
> > [email protected]
> > 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.

[MarkM]

Paul, I sent you an email.

"paul" wrote:

> what is your email address i will send you an example
> --
> paul
> [email protected]
> 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
> > > [email protected]
> > > 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.