Nevermind, I found the thread.

"OssieMac" wrote:

Hi Brian,

I have posted code on your other thread for this. However, I see that you
have been offered direct help by JLatham via email so go for it; afterall he
is an MVP so he could well provide a better answer than I have.

--
Regards,

OssieMac


"Brian" wrote:

I have a Workbook "Master User Form" Worksheet (Legacy B) that has all the
Data on it.

My combo boxes are as follows:
Combo box 1 = Customer_11 (Approx 8 customers)
Combo box 2 = State_11 (Approx 9 States)
Combo box 3 = CLLI_Code_1 (400 Offices per State)

My goal is
The user to Select from Combo Box 1 (Customer_11)

That narrows the selection down to what state for that customer
which is Combo box 2 (State_11)

When combo Box 2 is selected that narrows down the selection to only the CLLI
codes Combo Box 3 for that customer in that state.

Now on my Worksheet all the data is in columns as shown below

Data in Worksheet
--------------------------------
GEORGIA OFFICES
CLLI NAME ADDRESS 1 ADDRESS 2 CITY STATE ZIP GLC Code T-Base

Each Customers Info is in the rows. Each row contains 1 customer.

If the Data needs to be rearanged another way tell me and I will change it.

What I planned was for each Customer to have there own Worksheet broke down
by State.

Example: Customer 1 That customer is in 9-States

States = AL, Fl, GA, KY, LA, MS, NC, SC, TN

CLLI = ATLNGACS Each state has approx 400 sites for that customer.

I want to do this the easiest way possible, so if that data has to be moved
around then the girl at the office has job security. LOL

Any help or sugestions would be greatly apprieciated.



"JLatham" wrote:

On second thought, that page at Contextures may not be what you want. I
realized after posting you're speaking of combo boxes on a UserForm, not data
validation lists on the worksheet.

To really help, it would be useful to know what you intend to use each combo
box for, and what a change in one of them would do for the next one in the
sequence.

You'll (probably) want to set them up initially in the Form's Initialize
event, then alter the source rows for the 'downstream' combo boxes based on a
change in the upstream boxes.

"Brian" wrote:

I have a user form with 3 combo boxes that I would like to set up to narrow
down information on a worksheet in the same workbook as the User Form.

Can anyone help me or guide me on how to do it?

Data in Worksheet
--------------------------------
GEORGIA OFFICES
CLLI NAME ADDRESS 1 ADDRESS 2 CITY STATE ZIP GLC Code T-Base

Data is layed out across the worksheet.

Data in Worksheet
--------------------------------
Clli: ACWOGAMA
Add 1: 4745 Logan Road
City: Acworth
St: GA
Zip: 30101
GLC: F5341

Clli: AGSTGAAU
Add 1: 3523 Washington Street
City: Augusta
St: GA
Zip: 30907
GLC: R3547

Clli: AGSTGABM
Add 1: 1490 Ellis Street
City: Augusta
St: GA
Zip: 30902
GLC: R6341