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.
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.
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.
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.
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
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 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.
//www.pk-anexcelexpert.com
Post navigation
DOWNLOAD YOUR FREE WORKBOOK
Where would you
like us to send your FREE Excel Workbook?
Sachin Dung
"I made it and it came out very well"Read More
It was awesome. I made it and it came out very well. Thank you sir
Waqas Azeem
"The way you present the lesson and handle Excel is so beautiful"Read More
You're a superstar… The way you present the lesson and handle excel is so beautiful. I was able to impress my company head, thanks to you. Another amazing video
Paul Forster
"This exactly what I've been after"Read More
This is exactly what I've been after. Thank you
Muhammad Shahbaz
"Every week we learn and enjoy amazing things and ideas"Read More
Every week we learn and enjoy amazing things and ideas. Special thanks Randy Austin.
Udom Akpan
"I've watched it over and over"Read More
This is wonderful, I've watched it over and over and I've pen it down as one of my future application. Thanks Mr. Randy
Erika Bailey
"It helped me get over my fear of a blank sheet"Read More
Excited! Honestly I appreciate you starting from a blank spreadsheet so much. It helped me get over my fear of a blank sheet. Thanks as always, Randy
Felix Yankey
"Always on top of his game"Read More
Randy is always on top of his game
Satyen Purohit
"Oh My God now this is insane"Read More
Oh My God now this is insane.. Love you sir for all your hard work
Thamer Al-qershi
"You make me cry"Read More
Phemelo Khomane
"This man is a guru"Read More
This man is a guru I tell you. Learning new things everyday from him
We respect your privacy and will never share, sell or abuse your email.
*For Gmail Users, Please Check Your Promotions Folder