Hello,

I have a series of listboxs and would like for a selection to limit the
information in the next.

Example:

Territory# ShowOnlyMarketsTerr# ShowOnlyAcctsTerr#
610 610 A market 610 ABC Account
620 610 ABC market 620 DDD Account
630 620 A market 630 ABC Account

When 610 is selected in Territory, I need ShowOnlyMarketsTerr# and
ShowOnlyAcctsTerr# to show only listings that begin in 610. Is this possible?

Thanks in advance for any help.
Mike

http://www.contextures.com/xlDataVal02.html
here is how to do it
--
Allllen


"k1200gt" wrote:

> Hello,
>
> I have a series of listboxs and would like for a selection to limit the
> information in the next.
>
> Example:
>
> Territory# ShowOnlyMarketsTerr# ShowOnlyAcctsTerr#
> 610 610 A market 610 ABC Account
> 620 610 ABC market 620 DDD Account
> 630 620 A market 630 ABC Account
>
> When 610 is selected in Territory, I need ShowOnlyMarketsTerr# and
> ShowOnlyAcctsTerr# to show only listings that begin in 610. Is this possible?
>
> Thanks in advance for any help.
> Mike

Allen,

Thank you for the response. I was not clear enough regarding my task. I am
doing this in a user form and there are four list boxes, each limmiting the
next. I am stumbling my way through it with code.

I have it working to limit, but I have errors when reselecting. For
instance, a Territory can be chose several times and the Market and Account
information will change accordingly. However, if after selecting a
Territory, I select a Market and then try to select a new Territory, I get
errors.

Mike

"Allllen" wrote:

> http://www.contextures.com/xlDataVal02.html
> here is how to do it
> --
> Allllen
>
>
> "k1200gt" wrote:
>
> > Hello,
> >
> > I have a series of listboxs and would like for a selection to limit the
> > information in the next.
> >
> > Example:
> >
> > Territory# ShowOnlyMarketsTerr# ShowOnlyAcctsTerr#
> > 610 610 A market 610 ABC Account
> > 620 610 ABC market 620 DDD Account
> > 630 620 A market 630 ABC Account
> >
> > When 610 is selected in Territory, I need ShowOnlyMarketsTerr# and
> > ShowOnlyAcctsTerr# to show only listings that begin in 610. Is this possible?
> >
> > Thanks in advance for any help.
> > Mike