Spreadsheet Formulas

css navigation by Css3Menu.com

Using Validation

So, you want to choose from a combo box but do not really want to use code to do it. There is a cool way to do it in Excel with Validation.

Here is a cool “movie” I recorded in Snag-it to show you how easy it is.

AVI movie of Validation example

Note: This AVI file is 26 MB and should probably be downloaded before running.

The only limitation is that the lookup list must be on the same sheet.

© 2007-2024

Updated:  04/17/2024 12:26
This page added:  17 December 2007