thanks for your reply - got most of your instructions, wasn't sure about
the button?? I dont have a button, I was hoping, in the validation list,
if i an option "add new", a prompt box could come up, you type it in and
then it adds it into the list?


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=500111