Spreadsheet Formulas

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.

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.

Updated:	11/16/2009 23:41
This page added:	17 December 2007