Data Validation on Data Entry Form
 

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

Data Validation on Data Entry Form
 

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

Trevor Aiston wrote:

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