thanks a bunch. it worked and solved my problem.

"מיכאל (מיקי) אבידן" wrote:

Upon declaring the DV click on the 'Errors alert' tab and de-select the
option 'Show Error error for illegal entries'
Micky


"t" wrote:

i can create a list using the data validation btu would also like to be able
to type text in the same cell. is this possible?