The J-Walk Enhanced Data Form
The J-Walk Enhanced Data Form is a FREE Excel add-in that provides a general-purpose data entry dialog box. The Enhanced Data Form adjusts to any database table in any worksheet. It's a significantly enhanced alternative to Excel's built-in Data Form (which is not even part of the user interface in Excel 2007 and later).
Very Important: This add-in comes in two sub-versions, and both are included in the download:
- Version 3a - for Excel 97, 2000, 2002, and 2003
- Version 3b - for Excel 2007 and later
This add-in does not work with any version of Excel for Macintosh.
What's new in Version 3?
Click here for a complete list of Enhanced Data Form features. The new features in version 3 are:
- The ability to change the dimensions of the Form dynamically. When the form is displayed, just click the lower right corner and drag to make the form taller, shorter, wider, and narrower. If you prefer that the user not have this ability, that's also an option.
The ability to specify a different width for the field names. In the previous version, the field width was always a fixed size. Version 3 can accommodate database tables that have lengthy field names.
Improved support for non-American date formats.
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. Others are just curious to see how it works. The VBA project is protected, but you can purchase the password for US $15.00. The password will let you examine every line of code in the project (including the XML code that creates the Ribbon icon in the Excel 2007 version).
- Note: Even though Version 3 has more features, the price for the password has been reduced from the previous $20.