This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)

This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)

 

 

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) 

 

Related Topics:

• Excel VBA IF THEN Statement (with ELSEIF and Looping in cells) 
• Excel VBA basics: Data types, DIM and SET (Learn to use them correctly) 
• Copy and Paste in Excel VBA (copy, pastespecial, resize and offset) 
• Excel VBA: Referring to Ranges and Writing to Cells (Range, Cells, Offset, Names)