Templates

Data Entry Form in Excel

This data entry form has been designed in VBA. You can enter the EMP ID, EMP Name, Gender, Designation and Salary. Since Excel sheet is protected so data can not be changed manually.

Data Entry Form Output
Data Entry Form Output

There are three buttons available in this worksheet.

1.Add New Record

By using this button a record can be added on the worksheet. Below given form will be opened after clicking on this button.

Add New Record form
Add New Record form

2.Update Existing Record

By using this button an existing record can be modified on the worksheet. Below given form will be opened after clicking on this button.

Update Existing Record Form
Update Existing Record Form

3.Delete Record

By using this button an existing record can be delete. Select a record and press this button. Before delete the record it will ask you “Do you want to delete this record“. If you click on Yes then it will delete that record.

Delete a record
Delete a record

Click here to download the Data Entry Form in Excel

Watch the video tutorial to learn how to create this data entry form in Excel

 

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply

Your email address will not be published. Required fields are marked *