How to Create a Data Entry Form in Excel With Add, Modify, Delete and Reset (Step-by-step Guide)

In this video, we will discuss and develop an Automted Employee Data Entry in Excel with some advanced features e.g. Add, Modify, Delete, Reset.

#AutomatedForm #TheDataLabs

Please follow the below link to download the Excel files (automated form ) used in this video.

Thanks for watching!

Please like, share, comment and subscribe.

Have a great day!

[Leo-smci]

4:00 Make Form
20:55 Make Database
26:35 Insert Module
45:00 Sub Reset
48:00 Sub Save
58:15 Sub Modify
1:07:45 Sub Delete
1:12:40 Click Save

[ricardomiller]

This is probably the best Excel tutorial I have watched. I like the fact that you did not edit out your errors but show them as they appeared and so i learned how to correct them and the reason behind each change. Very well done.

[noor.]

You are awesome man. Great and easy way of explanation. I was always scared to learn these things as they look very complicated, but you made it very simple and easy. Thank you so much. I am very very thankful to you. And would like to request you please keep the good work going on.

[MsYongbang]

This is my first time following a step-by-step tutorial for Excel. I am way past my bedtime, but I have enjoyed it a lot. I followed every single step that I even incurred the same error, ha, ha, ha. But, that is totally fine, since I have learned something today. Thank you so much!

[lacpeb]

I am 21 minutes into this video, and I have already created an amazing cake order form for our retail bakery. I don't know how I stumbled on to this video, but it is fantastic. I cannot say enough good things about it. The instruction is easy to follow, and the result (so far) is beyond my wildest dreams. I cannot thank you enough.

[iuhshwth]

Sir, you have no idea how much you helped me with this tutorial video. I got to understand the concept of how everything works so I can apply it to different types of data and I can actually finish my works for studies to get passed to 2nd semester. I just want to shake your hand and say thank you so much in person 🤝

[kidskona]

I actually completed the entire one hour plus video, it is very detailed and helps a lot.

[juanvasquez]

Well done! This tutorial was easy to follow along and apply to day to day functions.

[brandonsirhan]

This has been greatly informative/helpful!!! I would suggest though for anyone that does not want to alter an entry that was previously pulled up with "Modify" after resetting said entry with "Reset", to make the cells (in this case) L1 and M1 both equal to "" in the reset function.

[githeshs]

This is the best tutorial, very helpful and easy learning. You are teaching very clearly and step by srep. Thanks a lot and hope more videos ahead. Excellent and fabulous.

[ammarbolton]

Liked the way you delivered and explained the entry data . Loved it and subscribed. Well done!

[florisbotes]

Awesomely done your tutor skill is excellent. I'm trying to learn VBA, not reverse engineering that's easy but for a novice like myself I could follow you all the way and actually now start to understand VBA coding language concept... I'm going to look trough you videos now without stopping...

[caloyskingespiritu]

thanks for this very informative lecture, it refresh my COBOL Programing knowledge..😊😊😊

[hadlump]

So useful and such clear explanations. I am really glad I discovered this. I have added it to Favourites.

[elizabethportela]

Thank you so much for your detailed explanations and step by step tutorial! This was exactly what I needed for my company's data collection tool!

[zackmekintoshcolins]

Thank you broder for this tutorial this is a decent tutorial I found here in youtube so far

[tongallegos]

amazing! thanks a lot! i suggest to add a video after the data have been saved, it will be sent and received email notification via MS outlook 👍

[mommak]

Thank You for this tutorial. I was able to follow along and input the code for my home inventory entries, took a little longer and some error, but I was able to figure it out. I have no clue how to code with Excel and VB. I was trying to make a windows application that sat on the desktop for home inventory and after clicking enter it would send the data to an excel spreadsheet, then I found your video I still haven't figured windows app in VB at all, nor what kind of project extension it should be. Eventually I will and until then I will use the one I just made watching your video.

[elledragneel_spacehub]

Hi Sir, thanks for sharing information. You are great at teaching. I hope many people can learn through your videos.

[samsundersagayanathan]

Thank you very much. This is very very helpful. I did my first Macro and would like to more, please support with more videos