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.
thedatalabs.org/advance-data-...
Please visit our website www.thedatalabs.org
Please contact us on thedatalabs@gmail.com
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!

Пікірлер: 763

  • @Leo-sm7ci
    @Leo-sm7ci2 жыл бұрын

    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

  • @Sindhusaraswat

    @Sindhusaraswat

    11 ай бұрын

    Someone please help, I am not from coding background Sub Modify() Dim iRow As Long Dim iSerial As Long iSerial = Application.InputBox("Please enter Serial Number to make Modification.", "Modify", , , , , , 1) On Error Resume Next iRow = Application.WorksheetFunction.IfError_ (Application.WorksheetFunction.Match(iSerial, Sheets("Database").Range("A:A"), 0), 0) This shown Compile error: Expected: line number or label or statement or end of statement. Please help 🙏

  • @ricardomiller1519
    @ricardomiller15193 жыл бұрын

    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.3385
    @noor.33853 жыл бұрын

    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.

  • @lacpeb
    @lacpeb2 жыл бұрын

    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.

  • @nokpiadariusconstantino1333

    @nokpiadariusconstantino1333

    2 жыл бұрын

    Ясат пт

  • @juanvasquez3235
    @juanvasquez32353 жыл бұрын

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

  • @kidskona3287
    @kidskona32872 жыл бұрын

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

  • @iuhshwth1634
    @iuhshwth16344 жыл бұрын

    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 🤝

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Glad to hear that you found this tutorial useful. Thanks! 🤝

  • @MsYongbang
    @MsYongbang3 жыл бұрын

    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!

  • @thedatalabs

    @thedatalabs

    3 жыл бұрын

    Thanks for your feedback!

  • @ammarbolton4968
    @ammarbolton49683 жыл бұрын

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

  • @githeshs5905
    @githeshs59053 жыл бұрын

    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.

  • @GrahamSchroder
    @GrahamSchroder4 жыл бұрын

    That was awesome! Thanks for this, it helps a lot.

  • @caloyskingespiritu5719
    @caloyskingespiritu57194 жыл бұрын

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

  • @zackmekintoshcolins6485
    @zackmekintoshcolins64853 жыл бұрын

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

  • @elizabethportela5668
    @elizabethportela5668 Жыл бұрын

    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!

  • @jaironaranjo3654
    @jaironaranjo36544 жыл бұрын

    Thank you Mr Kamur you did an excellent presentation

  • @hadlump
    @hadlump3 жыл бұрын

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

  • @davidsumner397
    @davidsumner3972 жыл бұрын

    DING, DING, DING, WE HAVE A WINNER. Thank you so much. I was stuck on a project and your video posted 11 minutes in and was just the topic i was looking for. you are Awesome, keep it up,

  • @monaraejenkins3866
    @monaraejenkins38663 жыл бұрын

    Genius!!! Thanks for teaching this process!!!!!

  • @mconsulting7394
    @mconsulting73949 ай бұрын

    Thank you! I found all the errors by myself. Perfect experience and study.

  • @florisbotes193
    @florisbotes193 Жыл бұрын

    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...

  • @brandonsirhan8042
    @brandonsirhan8042 Жыл бұрын

    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.

  • @Swamhtetyan
    @Swamhtetyan4 жыл бұрын

    Very good your Excel and VBA , Thank you sir

  • @elledragneel_spacehub4140
    @elledragneel_spacehub41403 жыл бұрын

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

  • @brendan3464
    @brendan34643 жыл бұрын

    Thank you! Best tutorial🙌🏼

  • @user-et9rq8po4g
    @user-et9rq8po4g4 жыл бұрын

    Best tutorial in youtube 💕💕💕💕💕💕💕

  • @Paren_Tattoo93
    @Paren_Tattoo93 Жыл бұрын

    I always come to this video to learn some coding.. still useful in 2023 tq so much sir..

  • @yourdeveloper35
    @yourdeveloper353 жыл бұрын

    Thaaank you so much 😘 Well appreciated ❤️

  • @muhammadirfankhan3265
    @muhammadirfankhan32653 жыл бұрын

    This is awesome....a very simple and dynamic design....keep up the good work.

  • @samsundersagayanathan8192
    @samsundersagayanathan81924 жыл бұрын

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

  • @dilboo44
    @dilboo443 жыл бұрын

    Very useful . Really I have been searching for this life of example.

  • @codalisa007
    @codalisa0074 жыл бұрын

    Another excellent video.

  • @slotto4922
    @slotto49222 жыл бұрын

    Thanks for this! Well written and very helpful

  • @omegaunisex
    @omegaunisex2 жыл бұрын

    Awesome!! You are a good teacher. I will keep following you. Good job. Bless you.

  • @sidathfonterra3849
    @sidathfonterra38493 жыл бұрын

    Very informative and helpful. Thanks.

  • @haidsyacob7154
    @haidsyacob71544 жыл бұрын

    Thank you for this tutorial very helpful. I hope for the next video, about the addition, subtraction, division and multiplication.

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Thanks for your feedback! Please share your idea on our email id. Thanks!

  • @danthedeekzfan

    @danthedeekzfan

    2 жыл бұрын

    Has this been created?

  • @tongallegos2680
    @tongallegos26803 жыл бұрын

    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 👍

  • @cs.mmt9927
    @cs.mmt99273 жыл бұрын

    Fantastic thankful for for your help supplying full details clear enough

  • @farishussain1567
    @farishussain15674 жыл бұрын

    Thank you soo much this video really helps me

  • @chikabells5296
    @chikabells52962 жыл бұрын

    This tutorial I learned a lot of information to start of my projects using macro. Thanks ❤️ Alhamdulilah. More videos please ❤️

  • @efftsii
    @efftsii2 жыл бұрын

    Thanks bro. Working on collecting data on a project and your video has helped me to do up a data base.Thanks bro

  • @cobra777888
    @cobra7778882 жыл бұрын

    Thanks Brother, it is great. You have explained each and everything clearly. Thankyou So much.

  • @fitsumkassahun8290
    @fitsumkassahun82904 жыл бұрын

    Wow, thank you very much.

  • @sokhaputh2092
    @sokhaputh20922 жыл бұрын

    with my humble respect for your hard work. from Cambodia🙏🙏🙏🙏🙏

  • @thedatalabs

    @thedatalabs

    2 жыл бұрын

    Thanks!

  • @venecksfennuelfaivera1925
    @venecksfennuelfaivera19253 жыл бұрын

    This video is awesome. I can now develop database with Excel.

  • @mommak5691
    @mommak56913 жыл бұрын

    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.

  • @michaelhenderson5098
    @michaelhenderson50983 ай бұрын

    Thank you. This video was very helpful. I was able to create my own data entry for sales.

  • @kapaunkelo6939
    @kapaunkelo69394 жыл бұрын

    This is very useful, Thank you, can you please make one with a multiple databases and search button please

  • @tadashi2392
    @tadashi23923 жыл бұрын

    Thank you very much for this great content. A huge help for me..

  • @teslateb1545
    @teslateb15452 жыл бұрын

    Sir your works are very educative and helpful. Thanks a lot for the informative videos which have been very handy.

  • @estherm9102
    @estherm9102 Жыл бұрын

    Thank you. It works PERFECTLY!

  • @africanperspectives9353
    @africanperspectives93533 жыл бұрын

    I enjoyed the first part. Coding is somehow complicated. But you have done an excellent work.

  • @thedatalabs

    @thedatalabs

    3 жыл бұрын

    Thanks for your feedback! Please subscribe our channel.

  • @phistoanonymous1798
    @phistoanonymous17982 жыл бұрын

    This was extremely helpful. Thank you

  • @afzalhossain4141
    @afzalhossain41414 жыл бұрын

    Thank a lot. its very beneficial to me.

  • @virajdesai239
    @virajdesai2392 жыл бұрын

    This is amazing.... Really helped a lot.. THANK YOU!!

  • @rubylosbanos4358
    @rubylosbanos43583 жыл бұрын

    Thank you for sharing your brilliant knowledge. I do try my own data developing here. hope you can guide me with my project. thank you.

  • @ananyapatnaik2748
    @ananyapatnaik27484 жыл бұрын

    This tutorial was awesome and it helped me and fulfilled by purpose of building a form for business use :) Thanks a lot .

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Thanks for your appreciation!

  • @nokpiadariusconstantino1333

    @nokpiadariusconstantino1333

    2 жыл бұрын

    Цдддд кдтуузаээагшри

  • @nokpiadariusconstantino1333

    @nokpiadariusconstantino1333

    2 жыл бұрын

    Цдддд кдтуузаээагшри

  • @shaundupreez4889
    @shaundupreez4889 Жыл бұрын

    This tutorial is very well done. Thanks so much for putting in the time to make this. Subscribed for more

  • @GG-ts7nj
    @GG-ts7nj2 жыл бұрын

    It's Most Mind Blowing Training for US [ New Students ]

  • @yuza6023
    @yuza60234 жыл бұрын

    very helpfull, subscribed

  • @akila_the_third
    @akila_the_third3 жыл бұрын

    Great video, 👌🏾

  • @vanessawhite5125
    @vanessawhite51252 жыл бұрын

    Thank you so much for the amazing tutorials

  • @AnimationSlot3600
    @AnimationSlot36004 жыл бұрын

    Thank you Admin !! That is it i subscribe 🇵🇰

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Thanks!

  • @pregaramen8747
    @pregaramen87472 жыл бұрын

    awesome , very helpful and explicit video. Thank you very much sir. from mauritius.

  • @farzanrazick7166
    @farzanrazick71663 жыл бұрын

    Very Useful and GOD bless you.....

  • @putuagus5950
    @putuagus59503 жыл бұрын

    Hello Sir, Thanks so much...good toturial

  • @florinpopescu3779
    @florinpopescu37794 жыл бұрын

    Verry useful the code. Thanks !

  • @marcjosephferrer3262
    @marcjosephferrer32623 жыл бұрын

    thank you for sharing bro!

  • @ms.shengyouvlog2832
    @ms.shengyouvlog28324 жыл бұрын

    Its useful for my work..

  • @clayvlogg605
    @clayvlogg6053 жыл бұрын

    Very helpful information....👍

  • @charlesstrickland9007
    @charlesstrickland90072 жыл бұрын

    Great Job on form! Thanks

  • @abdulmajeedkhan8143
    @abdulmajeedkhan81433 жыл бұрын

    thank you so much for this awesome tutorial n too much love and respect for you

  • @thedatalabs

    @thedatalabs

    3 жыл бұрын

    Thanks for your feedback!

  • @sadiyaprincess7513
    @sadiyaprincess75134 жыл бұрын

    Thank you sir,

  • @yinthuaung9838
    @yinthuaung98382 жыл бұрын

    Thanks Sir! i want to learn user form and Active X Control tools. U r really expert.🙏😍

  • @AdamKlinger
    @AdamKlinger3 жыл бұрын

    Thank you thank you!

  • @ayumiyamada9562
    @ayumiyamada95622 жыл бұрын

    Thank you so much. I learned a lot.

  • @vladimir7821
    @vladimir78214 жыл бұрын

    superb work

  • @AnilSingh-yt7ci
    @AnilSingh-yt7ci4 жыл бұрын

    Thank you Sir you really teach in a very simple and easy way. If you can teach about school fee structure and fee receipt.

  • @erielleoborro5392
    @erielleoborro53924 жыл бұрын

    Thanks. It works 💗

  • @rohitgurung909
    @rohitgurung9094 жыл бұрын

    This is awesome....a very simple and dynamic design....keep up the good work...

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Thanks for your appreciation!

  • @malaeamaake3923

    @malaeamaake3923

    3 жыл бұрын

    @@thedatalabs? Ow?

  • @malaeamaake3923

    @malaeamaake3923

    3 жыл бұрын

    @@thedatalabs? Touch and hold a clip to pin it. Unpinned clips will bSocial fund paper for all e deleted after 1 hour.....

  • @mohamedshihar2488

    @mohamedshihar2488

    3 жыл бұрын

    HI CAN YOU HELP ME

  • @dmmianwali8833

    @dmmianwali8833

    3 жыл бұрын

    @@thedatalabs Sir please share VB Code for create database

  • @arunlaxmanraut
    @arunlaxmanraut Жыл бұрын

    सर माहिती फारच छान आहे फार फार धन्यवाद सर !.......

  • @microsoftsarker
    @microsoftsarker2 жыл бұрын

    Thanks, Useful tutorial

  • @sahucr
    @sahucr4 жыл бұрын

    Very good explanation 👍

  • @varmasknowledgehub5235
    @varmasknowledgehub52353 жыл бұрын

    Awesome explanation....👍👍

  • @siluskwemboi
    @siluskwemboi3 жыл бұрын

    You are the best!

  • @durgam_sumerian7815
    @durgam_sumerian78154 жыл бұрын

    that's it, i subscribed

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Thanks!

  • @HossamElgnainy
    @HossamElgnainy2 жыл бұрын

    Thank you you, this helped me too much

  • @balajik8212
    @balajik82124 жыл бұрын

    Good and great , excellent clear explanation, super sir, thanks to u

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Thanks for your feedback!

  • @tecpulsevision3292
    @tecpulsevision32922 жыл бұрын

    Great, helpful for beginners ...

  • @wnxbha6120
    @wnxbha61203 жыл бұрын

    hello thank you for the great video! request for inward and outward correspondence database system tutorial

  • @gng.galagar4282
    @gng.galagar428210 ай бұрын

    Thank you so much, I will use in our school.

  • @danielmoseskuma7921
    @danielmoseskuma79212 жыл бұрын

    very quick and easy and easy to learn.

  • @jhowillopez2087
    @jhowillopez20874 жыл бұрын

    Make my excel life easy.. #Thank you #Subscribed

  • @ashokuppalapati2688
    @ashokuppalapati26884 жыл бұрын

    Excellent Bro

  • @lhendupgyeltshen3568
    @lhendupgyeltshen35684 жыл бұрын

    Very useful and simple. easy to catch step by step due to slow motion in teaching. good work keep it up

  • @thedatalabs

    @thedatalabs

    4 жыл бұрын

    Thanks for your feedback!

  • @yami-me5ox

    @yami-me5ox

    Жыл бұрын

    @@thedatalabs Error

  • @thedatalabs

    @thedatalabs

    Жыл бұрын

    Please share the line of code where you are getting the error. Thanks!

  • @electricus_aniruddhachanda8184
    @electricus_aniruddhachanda81842 жыл бұрын

    Really excillent table. Grat Sir. The grate thing is hear you did not use any coding

  • @lethargic.
    @lethargic.3 жыл бұрын

    thank you :)

  • @sandunraj3309
    @sandunraj33092 жыл бұрын

    Thank you Very much... Awesome project.. also needs help for filter and print summary.

  • @izzahrasyidah703
    @izzahrasyidah7033 жыл бұрын

    subscribed !

  • @ruginathomas3873
    @ruginathomas38732 жыл бұрын

    Wow Thank you very much u made my day brother keep it up kindly i need the Payroll tutorial please 🙏

  • @kersonang5308
    @kersonang53083 жыл бұрын

    Thanks so much!!!