In this video you’ll learn a lot about combo box drop-down lists in Excel:
1. How to create a combo box drop-down list
2. How to create a dependent combobox drop-down.
3. How to restrict the combo box drop-down to exclude blank cells and the best part;
4. How to overcome the problem we face with dependent data validation lists where the dependent list doesn’t reset once the value for the first list is changed – you’ll learn an alternative method to overcome the failure to auto-reset (we’re going to automatically refresh the dependent list once the value for the first list changes)
Course Length: 12:56 minutes
Source: Leila Gharani