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