Excel Automated Data Entry 2.0

Excel Automated Data Entry 2.0


System Requirements:

1. Operating Sytem: Windows 7 and up (32 bit or 64 bit)
2. Office: Microsoft Excel 2013, Microsoft Excel 2016, and Microsoft Excel 2019 (32 bit or 64 bit)

  • v2.0.3 – September 29, 2020
  • v2.0.2 – September 13, 2020
  • v2.0.1 – September 5, 2020

jump to Download Page


It’s been a long time since I published the version 1.0 of this program written in VBA. Microsoft conducted no more developments on “.Net Visual Basic.” and is no longer supported. I stopped my development for its inadequate function that prevented me to develop further. However, I decided to switch to C# programming language through Visual Studio IDE.

(Note: Your concerns, feedbacks and recommendations for the enhancement of this program is highly appreciated and acknowledged.)

What’s the use and What’s new?

ADE is an Excel COM Add-in. A simple UI that is powerful to help users to record, edit, and manage data according to their preferences. The major update is Data Entry Details – it helps you provide more sufficient and detailed data base on your Main/Head Data Entry. The design can likewise be manipulated such as moving or resizing labels, textboxes, and groupbox. Moreover, inserting company name, title, and more are now applicable.

How to use

First, create a table for your data – this will be your working table.

Click the Data Entry Form button then select only the header columns and click Ok.

The settings are still on their default properties.

In order to change the settings, go to Menu Tab > Settings > Settings Head. After modifying your settings, go to File, click Save and restart the Data Entry Form.

For more details about Settings Head

However, if you wish to create more detailed entries, create a table to another sheet in order to fill the DataGrid Details.

Click File menu tab and find Fill DataGrid Details.

Choose the table from the new sheet (Details) that you created.

If you need help with configuration, go to Menu Tab > Settings > Settings Details and change their properties.

Finally, the customization of your own form. To customize, just go to Data Entry Designer. In here, you can change controls, size, positions, labels, title, datagrid, and userform according to your preferences. Don’t forget to save your work!

How to Install ADE

Feedback, Suggestions and Bug Report

Please send an email regarding with your concerns and kindly attach screenshot/s of error if needed. For some suggestions, we will provide an update as soon as we progress in the specific matter. Thank you!

Email me at:


Note: If you wish to donate and support this program, just click Donation on Menu Tab.Your donations for the enhancement and upgrade of this program are highly appreciated and acknowledged . Thank you!