Cascading list box
 

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