yes faz and dave petersen told you how,a combo box from the forms or control
toolbar.I prefer the forms version .It will be very easy to change as you
must already have your list of data to choose from,all you need to do is
choose a place for your cell link and then I use a choose or an index to
return the value chosen

--
paul
remove nospam for email addy!



"travelersway" wrote:


Thank you all, but is there no way to set up a cell with a drop down
list to keep the appearance it has when you click on it?


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=476747