xls data valadation question

[t]

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?

 

[מיכ×ל (מיקי) ×בידן]

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

 

[t]

thanks a bunch. it worked and solved my problem.

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