Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words and Spaces in 1st List

Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words and Spaces in 1st List

 

 

In that video the first list contained numbers whereas in this video we take a look at a more realistic case where the first list contains text with multiple words and spaces. This approach works if your drop downs are in different worksheets as well. 

Related Topics:

• Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook
• How to use the Message Box in Excel VBA (syntax you'll need for msgbox) 
• Excel VBA IF THEN Statement (with ELSEIF and Looping in cells)
• Excel VBA basics: Data types, DIM and SET (Learn to use them correctly)