Data Validation on Data Entry Form

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Validation list in data entry form	Steve M	Microsoft Excel Misc	4	5th May 2010 07:21 PM
data validation in form during data entry	=?Utf-8?B?c3RldmU=?=	Microsoft Access Forms	1	4th Mar 2007 09:00 PM
help on data entry validation on form	SG	Microsoft Access Form Coding	0	10th May 2005 04:55 PM
Data entry form with data validation - can I ?	=?Utf-8?B?VG9kZCBGLg==?=	Microsoft Excel Programming	0	28th Dec 2004 10:47 PM
Data entry form with validation	=?Utf-8?B?RGF2ZQ==?=	Microsoft Access Forms	1	2nd Jan 2004 03:22 PM