combo box selection

[rharri1972]

I have USERFORM3 and on it i have a combo box that is filled with a list of customers. This list of customers comes from a worksheet "Customers Select".

I need a few things to happen when I select from this combo box but I don't know how to tell it what to do with vba.

Example... When I select "Customer A" from COMBOBOX1 which is stored in cell A2 worksheet "Customers Select"....

I need the following to happen :

All of these textboxes are on userform 3....

value of Col B, whichever row, to go to textbox1
value of Col C, whichever row, to textbox 2,
value of Col D, whichever row, to textbox 3.
value of Col E, whichever row, to textbox 4
value of Col F, whichever row, to textbox 5
value of Col G, whichever row, to textbox 6

The range of my list in the combobox1 is A2:G1000 on the worksheet, so another dilemma is that each customer selected will be a different row. Customer Name is Column A.

If it helps, here are my values... Col A is Customer Name (obviously will stay in combobox)
Col B is Address 1 (textbox1)
Col C is Address 2 (textbox2)
Col D is City (textbox3)
Col E is State (textbox4)
Col F is Zip Code (textbox5)
Col G is Customer ID (textbox6)

If I haven't asked in a way that is easily understood, please let me know. One problem I have sometimes when trying to find through google is not knowing how to state what i'm looking for.

Thank you for any and all help!!!

 

[My Aswer Is This]

Looks like this is part of the same project I helped you with earlier.
And you said then load all the values In Range ("A2:G1000")
Into Combobox1

But now it looks like you're saying only the values in column A should be in the Combobox1.
So, if in Range "A2" you have "George"
Then you want what is in B2 Loaded into TextBox 1
Then you want what is in C2 Loaded into TextBox 2

Is this what you're wanting. And did you really want all the values in the entire range loaded into Combobox1?

 

[rharri1972]

Looks like this is part of the same project I helped you with earlier.
And you said then load all the values In Range ("A2:G1000")
Into Combobox1

But now it looks like you're saying only the values in column A should be in the Combobox1.
So, if in Range "A2" you have "George"
Then you want what is in B2 Loaded into TextBox 1
Then you want what is in C2 Loaded into TextBox 2

Is this what you're wanting. And did you really want all the values in the entire range loaded into Combobox1?

My Answer Is...so now that I look at it...I think i would only need the values from Column A&B in the combo box but then would want different textboxes loaded wtih values from specific cells in that customers row. I just haven't learned how to code what I want. I don't know how to say "these values load into combo box" and depending on the customer I select i need cell "x" to load into textbox 1 and so on. Basically the Textboxes will be for the Address (street address) a different box for City, different one for state and another for Zip and a final one for Customer ID. This is going to be for my Customer Order Form I am trying to build. If you are willing to help I would definitely appreciate any help.
Thanks!