One way
Data Data Validation.
Either Custom and add list there (Short lists) or Select list and
select range for list. More info attached on link
http://www.contextures.com/xlDataVal01.html
VBA Noob
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=563081