I am trying to make cascading combo boxes where: the user selects a country in the first combo box and the second combo box lists the cities within the country selected in the first combo box.

When I use data validation using indirect function, my model works perfectly but I really want to do it with combo boxes so that the user can go straight to a city by typing.

Your help will be much appreciated.

Thanks a bunch