Data Entry Form

This repository contains VBA modules, and forms created whilst working on the project.

The goal of this project is to create an intuitive data entry interface. There are three different forms. These forms are simple to use and have data validation built in to minimize errors and cut down on the amount of time needed for data entry.

Additionally, the forms are made to store entered data in an organized manner that facilitates management in the excel

Two modules that contain some codes needed to run the forms are also included in the project.

Here are pictures of the forms that were made.

Figure 1: Screenshot of the data entry form .

Figure 2: Screenshot of the data entry form-Save.

Figure 3: Screenshot of the data entry form-Update.

Figure 4: Screenshot of the data entry form-Final.

Structure

• Modules/: Contains standard modules (.bas files)
• Forms/: Contains user forms (.frm files)
• Workbook/: Contains the main workbook with macros (.xlsm file)

Usage

1. Download the repository.
2. Import the necessary .bas or .frm files into your VBA editor in Excel.
3. Open the .xlsm workbook to see the macros in action

License

MIT License