How to validate entries with Data Forms in xls 2003?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marc S. - 25 May 2006 14:57 GMT

I would like to find an option to validate my entries when using the data
form. The option I'm thinking of is to use pre-defined list of value.
Thanks for your help.

Reply to this Message

Dave Peterson - 25 May 2006 15:19 GMT

Maybe it's time to dump data|form and use John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The features say you can use dropdowns.
http://j-walk.com/ss/dataform/features.htm

And the source code is available for a small fee ($20 USA, IIRC).

> I would like to find an option to validate my entries when using the data
> form. The option I'm thinking of is to use pre-defined list of value.
> Thanks for your help.

Signature

Dave Peterson

Reply to this Message