Hi, thanks again for your help, I have set up the worksheet folowing
the information at the link you provided and it works well, except,
using a dropdown list is not suitable for my worksheet as there are
about 500 numbers and it would be quicker just to type the numbers in
rather than selecting it from the listbox. I unchecked the in-cell
dropdown but when i enter the correct numbers i get the error message
when i hit enter (i can click in another cell with the mouse and it
works fine, but would like it to work by hitting the enter key)
otherwise it is working fine. do you know if this is a bug or is there
another setting i'm missing.


Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile: http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=529481