ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How to validate entries with Data Forms in xls 2003? (https://www.excelbanter.com/setting-up-configuration-excel/90561-how-validate-entries-data-forms-xls-2003-a.html)

Marc S.

How to validate entries with Data Forms in xls 2003?
 
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.


Dave Peterson

How to validate entries with Data Forms in xls 2003?
 
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).

Marc S. wrote:

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.


--

Dave Peterson


All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com