data validation and forms
 

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

data validation and forms
 

any ideas on this?

--


Gary


"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

data validation and forms
 

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

data validation and forms
 

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