Data validation only works with manual entry.

Since you are receiving the data in your form, then write the code to
validate the entry.

--
Regards,
Tom Ogilvy

"Marianne" wrote in message
...
I created a spreadsheet and added a maco to launch the form. Then added
data
validation for one of the columns. When I use the form to enter data the
data
is not validated. I can type in the cell directly and the data is
validated
properly.

How can I fix this?

Appreciate your help.

Marianne