One of the most popular downloads at my Web site is the J-Walk Enhanced DataForm v2. It’s an add-in that provides an alternative to Excel’s built-in Data Form (accessed with Data – Form). Personally, I think the most efficient way to enter data into a worksheet is to do it directly. But, for some reason, many seem to prefer using a form.
I’m going to make an Excel 2007 version of this add-in, and I thought I might add a few new features while I’m at it. Besides a new UI, I’m going to try to incorporate Andy Pope’s clever Resizable UserForm technique.
Any other suggestions?
By the way, Excel’s built-in data entry form is not present in the Excel 2007 UI. To use the feature, you must customize your Quick Access Toolbar and add theForm command from the Commands Not in the Ribbon group.