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-2017

Updated:  09/30/2017 19:48
This page added:  17 December 2007