Combo Box - 2 columns of dependent data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tinsley - 08 Oct 2006 20:44 GMT

I am trying to set up a form that allows a user to choose a Customer Group
first in a Combo Box. Then, in a second box the user will choose a SIC code.
The issue is that there are hundreds of potential SIC codes for each Cust
Group. Is there a way to allow the SIC code input list to be limited to the
Customer Group selected?
Ex: If Cust Grp A1 is selected in Combo Box 1, then show only SIC Codes 1-60
in Box 2. If Cust Grp A2 is chosen, then show only 61-150 in Box 2 to be
selected?

Appreciate any help on this.

Reply to this Message

s boak - 09 Oct 2006 16:53 GMT

You may want to try dependent datavalidation.
I think this link may get you waht you need -
http://www.contextures.com/xlDataVal02.html
HTH
Steve

>I am trying to set up a form that allows a user to choose a Customer Group
> first in a Combo Box. Then, in a second box the user will choose a SIC
[quoted text clipped - 9 lines]
>
> Appreciate any help on this.

Reply to this Message

Tinsley - 10 Oct 2006 17:05 GMT

THANKS SO MUCH..Works like a charm. Do need to figure out the formula though

> You may want to try dependent datavalidation.
> I think this link may get you waht you need -
[quoted text clipped - 15 lines]
> >
> > Appreciate any help on this.

Reply to this Message