Goto menu DataValidation, set Allow to List, and enter the values as comma
delimited list

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"cedtech23" wrote in
message ...

How do you create a drop down menu in VBA

example a menu with the following options

Black
Red
Green


--
cedtech23
------------------------------------------------------------------------
cedtech23's Profile:
http://www.excelforum.com/member.php...o&userid=31022
View this thread: http://www.excelforum.com/showthread...hreadid=506963