ok thanks chip, will do. just wanted to make sure

--


Gary


"Chip Pearson" wrote in message
...
Data Validation only applies to input made by the user, with the keyboard and
mouse. It doesn't apply to changes made by VBA code. You'd have to write your
own validation routine in the form itself.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
what's the preferred way to use data validation with an input form? if data
is entered directly into a cell, validation works, if i use an input form,
it allows any entry.

--


Gary