dependent combobox question

[lilsnoop]

I have tried to locate past submissions with this problem without success, which would lead me to resolve my issue. So any help would be as always greatly appreciated. I'm trying to link two combo boxes via a user form. I'm trying to select a city in one combobox which in turn would provide a listing of zip codes for that particular city in the next combobox. I've attached a sample of what I'm trying to accomplish. I'm hoping this is possible via the use of a userform. Thanks for your time!

[rylo]

HI

Add the code

Please Login or Register  to view this content.

This will update the available zipcodes for the selected city.

HTH

rylo

[lilsnoop]

Thanks Rylo! I've pasted the code in, but it hasn't seemed to do anything for me.. any suggestions?

[lilsnoop]

It was my mistake, I realized I placed the code in the wrong spot! Thankyou so much for your assistance!!!

[lilsnoop]

Ok..I do have one more question if I may... In my actual spreadsheet the 1st available column to put my city information is in column "BK" and then my zip codes would be in Column's "BL" & "BM". I've altered the code to refelct the following

Please Login or Register  to view this content.

I also changed my the other code

Please Login or Register  to view this content.

to reflect the proper listing column, but although my city list appears in the drop down, my zip codes no longer are visible in that combobox. Any ideas what I might be doing wrong?

[BigBas]

Notice in the code that Rylo provided that the variable [i]i[/] is used in the loop to indicate the column to add to the zip code combobox. Since the first available zip code would not be in column 2, you have to change the line

Please Login or Register  to view this content.

. The variable i would have to equal the column that the first zip code is available in (count up to BK or BL), and use that.

[lilsnoop]

Thanks BigBas! Works great now!