Newer Version Available
Click here for the latest version.
What is it?
The J-Walk Enhanced Data Form is an Excel add-in that provides a general-purpose data entry dialog box. It's a significantly enhanced alternative to Excel's built-in Data Form -- the dialog box that appears when you select Form from the Data menu.
What's new in Version 2?
Version 2 is an upgraded version of the original J-Walk Enhanced Data Form. New features include:
- The ability to change the dimensions of the Form.
- The ability to use a drop-down Combo Box for selected fields (the default is a Text Box).
- Language customization. it's very easy to modify the Form's text for use in languages other than English. The VBA password is required in order to make this change.
- Handles prefixed text values properly (e.g., a 16-digit credit card number that's preceded by an apostrophe).
For a comparison between the Enhanced Data Form and Excel's built-in Data Form, click here. Requirements
The J-Walk Enhanced Data Form works with Excel 97 and later versions.
Problem
Be aware that the Enhanced Data Form may not handle non-English dates correctly. I've spent many hours working on this, and have not been able to find a solution.
Pricing
The Enhanced Data Form is free, and is not crippled in any way. It is provided with no strings attached, no nag messages, and no ads. It can be freely distributed and used without a license. However, it may not be sold, or included as part of any other product without the written permission of J-Walk & Associates.
VBA Source Code is Available
The Enhanced Data Form is very flexible, but some users may prefer to customize it for their needs. The VBA project is protected, but you can purchase the password for US $20.00.