Data Validation on Data Entry Form

[Trevor Aiston]

I have a workbook to enter data in with a seperate sheet which has a number
of defined name rages which are used to validated data entrty.

But when I try and use a data entry form I loose the validation.

Can you use valdation on forms?

Trevor

 

[Dave Peterson]

Maybe you can design your own userform and add as much validity as you want.