Fully Automated Data Entry User Form in Excel - Part 2 (Edit and Delete Records)

Fully Automated Form in Excel - Part 2 (Edit and Delete Features)

In this video, we will learn how to add EDIT and DELETE features in our existing Data Entry Form in Excel. This is the second part data entry tutorial.

#EditDelete #TheDataLabs

Please follow the below link to download the Excel file used in this video.

Please visit our website for learn more about Excel, Power BI, VBA and Visualization.

Thanks for watching!

Please like, share, comment and subscribe.

Have a great day!

[thedatalabs]

Please watch the Complete Tutorials (Part 1, 2, 3, 4 and 5) of creating Fully Automated Data Entry Form in Excel.

[SquireDAF]

I have wanted to try this type of things to help my work out for a few years, always wanted to learn some coding but get scared off or overwhelmed, yesterday tried another youtube guide but i was messing it up or misunderstanding the guy, many cups of tea and about 10 hours later gave in then saw this video and started and not trying hard and couple hours later its pretty much good to go to start with, thank you very much you are a lifesaver!!!

I cant find it yet but for some odd reason it skips 2 rows on the spreadsheet when first entry goes in so starts at row 3, then its ok will hopefully find it but untill then i am a happy man

[omv]

Best tutorial from TheDataLabs with right pace and clear explanation on VBA codes. Thank you very much Dilip...Great job!

[HolyQuran]

Thank you very much for amazing tutorial.
I've a question regarding video time stamp 20:49
When someone want to delete the 2nd record not the 3rd so why the Sr.No is not changing according to the Entry.
When I deleted the 2nd record the Sr.No 3 is not changed to 2nd.
Please help me out need quick. Thank you

[familiapipajose]

Man, you have no idea how many manhours you saved from my day to day at work with this tutorial. Thanks so much

[PatMcMorran]

This was a lifesaver. You just saved me several hours of work on a friday

[ajulie]

That is GREAT. Thank you very much!!! One thing I would have like to know is what would be the code for the Edit button when you have a check box... Very unexperienced with VBA... Again, thank you - users will love this!

[Mmmmmmmeowth]

Thank you so much! This series has helped me a lot!

[idle-idiotslabentertainmen]

You are doing a great job. Add videos where we can learn complete basics of VBA

[omv]

Hi DataLabs can you incorporate an "EXIT" function to this Data Entry form? Once the user click "Exit" you get a message "Do you want to save any changes?" if Yes, then it will Save then Close the Excel. Just thought it would be nice addition? So far you guys did a great job. Thanks

[mohammedfareed]

Thank you so much. I learned a lot by this video. With zero error😊

[carlgrigg]

Thank you for the tutorials, I have completed the first two and have managed to write the database I need along the way, when getting towards the end of number two I thought "I need a sort or search function now", just noticed the subject for part 3 so I know what I will be doing tomorrow :) thanks again.

[ramisignals]

You are superman i like your videos to much

Thanks A lot keep same

[michaelnakakubo]

Great help! Fixed my code with your video. Thanks!

[Arifkhan]

Dilip Kumar you are amazing thanks for the great videos I have subscribed and watch every video
Thanks 🙏

[abdelhalimachlouj]

Thank you so much man.
An amazing tutorial witch helped me a lot to understand the concept.
Keep it up and looking forward to your next videos ...

[rvjordan]

Good Day i realy love the method its very clear but as a it student before i'd notice some little miscalculation like in this video it can't delete the 1st data that we have and also regarding with date in its different from the first setting that shows just that thanks a lot no hate .

[nabilaltalebi]

Very simple and useful ... thanks a lot

[abdul-rahman-mahdi]

Perfect work, Thanks for sharing your knowledge.
I enjoyed watching.

[jbosler]

Hi I love the help videos they are wonderful and easy to follow. I have a question! What if I don't want to actually delete the record but want to move it over to another sheet. It will be moved from the original sheet to another sheet to store the data so it is not lost.