Excel - Data Validation Combo Box using Named Ranges

Set up the Workbook

Create a Dropdown List

Add the Combo box

Open the Properties Window 

Change the Combo Box Properties

Exit Design Mode 

Add the Code

Test the Code 

Adjust the Combo Box Properties

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London