ComboBox Help

[Luis_B]

Hey Guys,

I need help with two comboboxes where the options of the second Combobox depends on the option selected on the first Combobox. For example, (please see screenshot below) if a city besides Fort Myers is selected on the first Combobox, then the only option that I want on the second combobox is Fort Myers.

But if Fort Myers is selected on the first combobox, then the other cities should appear on the second combobox besides Fort Myers.

There are only 5 cities to choose from. I was trying to use ListFillRange to do this but I can't figure it out.

Any help would be appreciated

Thank you,

 

[James006]

Hi,

A few simple solutions :

Easy Steps Excel Dependent Drop Down List Data Validation

Easy steps for Excel dependent drop down list. Conditional data validation based on other cell, Region/City. Videos, written steps, get free Excel file

www.contextures.com

 

[Luis_B]

Hi, James. Thank you. I will take a look.

A few simple solutions :

https://www.contextures.com/xldataval02.htHi James, thankyou.

http://