Data Valiation and Excel Data Forms
 

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

Data Valiation and Excel Data Forms
 

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