For example, select "Fruit" in cell B2, and "apple, banana, peach" appear in the drop down list in cell C2. In this dependent data validation example, if a country is selected from the first drop down, only that country's cities appear in the next column's drop down list. After you learn the basics, you can use the Excel IF function to make the selection more flexible.
To see a video about how to work with drop-down lists, see Create and manage drop-down lists.
When you select a Region, event code clears the cell to the right. Enable Events = True Exit Sub End Sub Don't miss my latest Excel tips and videos!
To add the code, right-click the sheet tab, and click View Code. You might need to change the column number, to match the column number on your worksheet. Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
(34 printed pages) Introduction Looking at Validation The Required Field Validator Control The Compare Validator Control The Range Validator Control The Regular Expression Validator Control The Custom Validator Control The Validation Summary Control Conclusion In your studies of ASP.
NET, you might have been introduced to a number of different types of controls, whether HTML server controls or Web server controls.