Populate a activeX combobox from a selection of another combobox

Rusty VBA programmer needs help, been a while!!!!

Anybody, please help... I'm having fits with getting this to work!

What I'm trying to do is make a selection in one combobox (1). From that selection it populate the second combobox(2) with coorasponding information.

Table example:
Customer: Address:
at&t Wireless 7338 Hill Street Irving, Texas
at&t Wireless 4678 MacArthur Blvd. Grapevine, Texas
at&t Wireless 5353 Ft Sam Houston Blvd. Houston, Texas
T-Mobile 4343 Green street, Tampa Florida
T-Mobile 7474 Washington St. Dallas, Texas

ComboBox1 (cbcusname) Select customer, T-Mobile
ComboBox2 (cbaddress) Populate all the assosiate address for T-Mobile for another selection.

Goal is to do this with ActiveX ComboBoxs reading from a hidden sheet.

Now I've read several posts, checked multiple websites and just can't find right solution.. Help!!!

No, I was able to write this in a userform, but as a mass template decided to scrap that idea and do straight into Cells. I've got close a few time, but the second combo box would only fill one item.. I thought this was my for each loop issue... Earlier today, I delete all the code and have started over.. Trying to take it to a simple format one to another, and I still not able to get this to work...

I pulled out every VBA net book I got trying to remember how to do this, with no luck.. Should be that hard, that's what happens when you move up within an organization, you start to lose your basic skills that gave you so much pleasure.. Had the same issue the other day with SQL, took me all day to write a simple query in sqlplus..

If anybody has a example please share..

I was able to do this on a UserForm

Please Login or Register  to view this content.

I set the ComboBox2 to as Visible=False to force the first selection

Hope this helps