3 level Dependent List Combobox

[animas]

I have 3 columns Country, State and City. These columns are filled with appropriate data. I need 3 comboboxes for those 3 fields. So when I select a country in CountryCombo, only states of that country will create the StateCombo dropdown list.

How can I do this using vba?


Thanks.

 

[jeffreybrown]

I don't know vba for this, but this is worth taking a look at.

http://www.contextures.com/xlDataVal15.html

Sample file included for download.

 

[animas]

I need to use combobox for this. How to do it?