Look here at Debra Dalgleish's web page on the subject:

http://www.contextures.com/xlDataVal01.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Tammy" wrote in message
...
Help please excel; when I select a cell that has a drop down box I want it
to
open