Leading the way in Microsoft Office Development

Reference Articles - 2007

2007: Create a drop-down list from a range of cells

2007: Prevent invalid data entry in a worksheet

Reference Articles - 2003

2003: Change data validation settings

2003: Copy data validation settings

2003: Create a drop-down list from a range of cells

2003: Display or hide circles around invalid data

2003: Find cells that have data validation

2003: Prevent invalid data entry in a worksheet

2003: Remove data validation

2003: Troubleshoot data validation

Reference Articles - 2002

2002: Control user choices with lists in Excel

2002: Overview and samples of data validation

2002: Using other validation tools in Excel

Reference Articles - 2000

2000: Using a validation list in another worksheet or workbook