Check out http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KimR.Hammel" wrote in message
...
How do you create a pull down list in Excel? I would like to offer, say,
5
options in a pull down list and force the user to select a single one.

Other times, users simply enter a value into one or more cells.

A Command Button then takes them to the next page. Before doing so, I
need
Excel to check to see if a selection has been made (in the case of the
pull
down list) or if values have been entered into the appropriate cells.

Using the Data Validation option for the cells does not ensure that 1.) a
value has been entered, or 2.) the user has exited the cell--in which case
the Command Button will not work.

This must be simple but I'm yet to find it.

Thanks in advance