Depending on requirements, do a search for
1. ComboBox
2. Data Validation (see menu Data/Validation)
both of which require some sort of pre-defined list in a range of
cells.
--
BrianB
------------------------------------------------------------------------
BrianB's Profile:
http://www.excelforum.com/member.php...info&userid=55
View this thread:
http://www.excelforum.com/showthread...hreadid=272940