populate combobox with dropdown

Try as I might to figure it out myself, I haven't been able to. So I thought I'd throw it out to the interwebs.

I want to automatically populate a dropdown menu combobox based on an option selected from a previous dropdown menu combobox. For example, in the attached workbook, if I select Nashville for ComboBox1, I want to see a dropdown of Honkytonks, Opry at Ryman, and Centennial Park in ComboBox2.

As you'll see, I have already included code to make ComboBox1 distinct values. I'd like to keep that as is.

Thanks in advance!

VBAcombobox.xlsm

The first part of your userform initilize code (where you populate combobox1) is just fine. Remove the other stuff.

In the combobox1_change event put this code

Please Login or Register  to view this content.

Huzzah! It works. Thank you very much, sir.