[RESOLVED] Problem with data validation

Hi, I have a cell that has data validation (a list from another sheet), it displays the listbox with the possible values to be entered, but it lets the user type a non valid value using the keyboard.
I would like to know how can I prevent this from happening.
Thanks in advance

i take it the list box is really a combobox, you can stop the user from typing in it by putting keyascii = 0 in the keypress event, this will not stop the user from pasting into the box
otherwise in the combobox change event put code to loop through all the items and if the text does not match prevent the lost focus by activating the combobox

Thanks a lot