Good afternoon themax16

Why not use the Data Validation function, in the Allow box select
List, and then type your list of possible values into the Source box,
or highlight a range of cells containing allowed values.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389018