Тёмный

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

TheDataLabs
Подписаться 127 тыс.
Просмотров 1,4 млн
50% 1

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!

Опубликовано:

 

11 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 762   
@Leo-sm7ci
@Leo-sm7ci 2 года назад
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
@ricardomiller1519 3 года назад
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.3385 3 года назад
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
@MsYongbang 3 года назад
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!
@juanvasquez3235
@juanvasquez3235 3 года назад
Well done! This tutorial was easy to follow along and apply to day to day functions.
@iuhshwth1634
@iuhshwth1634 4 года назад
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! 🤝
@ammarbolton4968
@ammarbolton4968 3 года назад
Liked the way you delivered and explained the entry data . Loved it and subscribed. Well done!
@lacpeb
@lacpeb 2 года назад
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 года назад
Ясат пт
@kidskona3287
@kidskona3287 2 года назад
I actually completed the entire one hour plus video, it is very detailed and helps a lot.
@caloyskingespiritu5719
@caloyskingespiritu5719 4 года назад
thanks for this very informative lecture, it refresh my COBOL Programing knowledge..😊😊😊
@githeshs5905
@githeshs5905 3 года назад
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.
@hadlump
@hadlump 3 года назад
So useful and such clear explanations. I am really glad I discovered this. I have added it to Favourites.
@GrahamSchroder
@GrahamSchroder 4 года назад
That was awesome! Thanks for this, it helps a lot.
@zackmekintoshcolins6485
@zackmekintoshcolins6485 3 года назад
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
@jaironaranjo3654 4 года назад
Thank you Mr Kamur you did an excellent presentation
@haidsyacob7154
@haidsyacob7154 4 года назад
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?
@elledragneel_spacehub4140
@elledragneel_spacehub4140 3 года назад
Hi Sir, thanks for sharing information. You are great at teaching. I hope many people can learn through your videos.
@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.
@ananyapatnaik2748
@ananyapatnaik2748 4 года назад
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 года назад
Цдддд кдтуузаээагшри
@monaraejenkins3866
@monaraejenkins3866 3 года назад
Genius!!! Thanks for teaching this process!!!!!
@samsundersagayanathan8192
@samsundersagayanathan8192 4 года назад
Thank you very much. This is very very helpful. I did my first Macro and would like to more, please support with more videos
@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...
@Swamhtetyan
@Swamhtetyan 4 года назад
Very good your Excel and VBA , Thank you sir
@muhammadirfankhan3265
@muhammadirfankhan3265 3 года назад
This is awesome....a very simple and dynamic design....keep up the good work.
@davidsumner397
@davidsumner397 2 года назад
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,
@mconsulting7394
@mconsulting7394 9 месяцев назад
Thank you! I found all the errors by myself. Perfect experience and study.
@africanperspectives9353
@africanperspectives9353 3 года назад
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.
@Paren_Tattoo93
@Paren_Tattoo93 Год назад
I always come to this video to learn some coding.. still useful in 2023 tq so much sir..
@brendan3464
@brendan3464 3 года назад
Thank you! Best tutorial🙌🏼
@user-et9rq8po4g
@user-et9rq8po4g 4 года назад
Best tutorial in youtube 💕💕💕💕💕💕💕
@tongallegos2680
@tongallegos2680 3 года назад
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 👍
@sokhaputh2092
@sokhaputh2092 2 года назад
with my humble respect for your hard work. from Cambodia🙏🙏🙏🙏🙏
@thedatalabs
@thedatalabs 2 года назад
Thanks!
@kapaunkelo6939
@kapaunkelo6939 4 года назад
This is very useful, Thank you, can you please make one with a multiple databases and search button please
@dilboo44
@dilboo44 3 года назад
Very useful . Really I have been searching for this life of example.
@slotto4922
@slotto4922 2 года назад
Thanks for this! Well written and very helpful
@yourdeveloper35
@yourdeveloper35 3 года назад
Thaaank you so much 😘 Well appreciated ❤️
@cs.mmt9927
@cs.mmt9927 3 года назад
Fantastic thankful for for your help supplying full details clear enough
@omegaunisex
@omegaunisex 2 года назад
Awesome!! You are a good teacher. I will keep following you. Good job. Bless you.
@chikabells5296
@chikabells5296 2 года назад
This tutorial I learned a lot of information to start of my projects using macro. Thanks ❤️ Alhamdulilah. More videos please ❤️
@sidathfonterra3849
@sidathfonterra3849 3 года назад
Very informative and helpful. Thanks.
@codalisa007
@codalisa007 4 года назад
Another excellent video.
@GG-ts7nj
@GG-ts7nj 2 года назад
It's Most Mind Blowing Training for US [ New Students ]
@cobra777888
@cobra777888 2 года назад
Thanks Brother, it is great. You have explained each and everything clearly. Thankyou So much.
@teslateb1545
@teslateb1545 2 года назад
Sir your works are very educative and helpful. Thanks a lot for the informative videos which have been very handy.
@rohitgurung909
@rohitgurung909 4 года назад
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
@farishussain1567
@farishussain1567 4 года назад
Thank you soo much this video really helps me
@michaelhenderson5098
@michaelhenderson5098 3 месяца назад
Thank you. This video was very helpful. I was able to create my own data entry for sales.
@venecksfennuelfaivera1925
@venecksfennuelfaivera1925 3 года назад
This video is awesome. I can now develop database with Excel.
@tadashi2392
@tadashi2392 3 года назад
Thank you very much for this great content. A huge help for me..
@shaundupreez4889
@shaundupreez4889 Год назад
This tutorial is very well done. Thanks so much for putting in the time to make this. Subscribed for more
@estherm9102
@estherm9102 Год назад
Thank you. It works PERFECTLY!
@efftsii
@efftsii 2 года назад
Thanks bro. Working on collecting data on a project and your video has helped me to do up a data base.Thanks bro
@virajdesai239
@virajdesai239 2 года назад
This is amazing.... Really helped a lot.. THANK YOU!!
@mommak5691
@mommak5691 3 года назад
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.
@fitsumkassahun8290
@fitsumkassahun8290 4 года назад
Wow, thank you very much.
@phistoanonymous1798
@phistoanonymous1798 2 года назад
This was extremely helpful. Thank you
@afzalhossain4141
@afzalhossain4141 4 года назад
Thank a lot. its very beneficial to me.
@rubylosbanos4358
@rubylosbanos4358 3 года назад
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.
@farzanrazick7166
@farzanrazick7166 3 года назад
Very Useful and GOD bless you.....
@AnilSingh-yt7ci
@AnilSingh-yt7ci 4 года назад
Thank you Sir you really teach in a very simple and easy way. If you can teach about school fee structure and fee receipt.
@AnimationSlot3600
@AnimationSlot3600 4 года назад
Thank you Admin !! That is it i subscribe 🇵🇰
@thedatalabs
@thedatalabs 4 года назад
Thanks!
@vanessawhite5125
@vanessawhite5125 2 года назад
Thank you so much for the amazing tutorials
@pregaramen8747
@pregaramen8747 2 года назад
awesome , very helpful and explicit video. Thank you very much sir. from mauritius.
@abdulmajeedkhan8143
@abdulmajeedkhan8143 3 года назад
thank you so much for this awesome tutorial n too much love and respect for you
@thedatalabs
@thedatalabs 3 года назад
Thanks for your feedback!
@lhendupgyeltshen3568
@lhendupgyeltshen3568 4 года назад
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!
@arunlaxmanraut
@arunlaxmanraut Год назад
सर माहिती फारच छान आहे फार फार धन्यवाद सर !.......
@yuza6023
@yuza6023 4 года назад
very helpfull, subscribed
@yinthuaung9838
@yinthuaung9838 2 года назад
Thanks Sir! i want to learn user form and Active X Control tools. U r really expert.🙏😍
@akila_the_third
@akila_the_third 3 года назад
Great video, 👌🏾
@putuagus5950
@putuagus5950 3 года назад
Hello Sir, Thanks so much...good toturial
@florinpopescu3779
@florinpopescu3779 4 года назад
Verry useful the code. Thanks !
@charlesstrickland9007
@charlesstrickland9007 2 года назад
Great Job on form! Thanks
@balajik8212
@balajik8212 4 года назад
Good and great , excellent clear explanation, super sir, thanks to u
@thedatalabs
@thedatalabs 4 года назад
Thanks for your feedback!
@ms.shengyouvlog2832
@ms.shengyouvlog2832 4 года назад
Its useful for my work..
@marcjosephferrer3262
@marcjosephferrer3262 3 года назад
thank you for sharing bro!
@electricus_aniruddhachanda8184
@electricus_aniruddhachanda8184 2 года назад
Really excillent table. Grat Sir. The grate thing is hear you did not use any coding
@varmasknowledgehub5235
@varmasknowledgehub5235 3 года назад
Awesome explanation....👍👍
@triplextm4703
@triplextm4703 2 года назад
Hi there, First of all I would like to say thank you so much for the detailed tutorial here. I haven't coded for about 15 years (albeit very basic coding back then) and this was a perfect reintroduction! I have followed the majority of your tutorial but my data input cells start in the H column instead of I column. All seems to be working fine, except when I press save on the Entry Form I am faced with an error message: "Run-Time Error '13': Type mismatch" When I select debug, it highlights the following: "iserial = database.Cells(irow).Value + 1" Could you advise where I might have made a mistake here? Thanks Again!
@anthonymulweye3178
@anthonymulweye3178 2 года назад
Hello, I'm facing the same issue. Did you find a solution?
@sadiyaprincess7513
@sadiyaprincess7513 4 года назад
Thank you sir,
@AdamKlinger
@AdamKlinger 3 года назад
Thank you thank you!
@vladimir7821
@vladimir7821 4 года назад
superb work
@ayumiyamada9562
@ayumiyamada9562 2 года назад
Thank you so much. I learned a lot.
@jersonagabao8125
@jersonagabao8125 4 месяца назад
I learned a lot from this video. 😀😀😀
@erielleoborro5392
@erielleoborro5392 4 года назад
Thanks. It works 💗
@lucsaint-onge6323
@lucsaint-onge6323 4 месяца назад
Very instructive ! congrats !
@thedatalabs
@thedatalabs 4 месяца назад
Thanks for your feedback!
@danielmoseskuma7921
@danielmoseskuma7921 2 года назад
very quick and easy and easy to learn.
@clayvlogg605
@clayvlogg605 3 года назад
Very helpful information....👍
@tecpulsevision3292
@tecpulsevision3292 2 года назад
Great, helpful for beginners ...
@microsoftsarker
@microsoftsarker 2 года назад
Thanks, Useful tutorial
@romeolabine200
@romeolabine200 3 года назад
Thank you so so much..u just got a new fan here.
@thedatalabs
@thedatalabs 3 года назад
Thanks!
@kendonphua2139
@kendonphua2139 4 месяца назад
I am new subscriber, i folled your steps and ive got it. Thank you
@thedatalabs
@thedatalabs 4 месяца назад
Thanks!
@HossamElgnainy
@HossamElgnainy 2 года назад
Thank you you, this helped me too much
@anisaputrialiya2023
@anisaputrialiya2023 Год назад
1triliun like buat akun ini... terimakasihh banyakkk
@gng.galagar4282
@gng.galagar4282 10 месяцев назад
Thank you so much, I will use in our school.
@sahucr
@sahucr 4 года назад
Very good explanation 👍
@diya2909
@diya2909 4 года назад
Sir your all videos are very useful...please make one good project on multipage userform with lots of controls and conditions.
@marcooliveira9335
@marcooliveira9335 2 года назад
Thanks for this presentation
@Moizfoodi
@Moizfoodi 3 года назад
thanks ..... done a great job....
@omniinfo6914
@omniinfo6914 2 года назад
Very helpful and good way to explain.Keep it up man👍
@thedatalabs
@thedatalabs 2 года назад
Glad it helped, thanks!
Далее
Try not to Laugh Game!
00:38
Просмотров 4,6 млн
How to make Macro enabled Form in Excel Sheet?
17:49
Просмотров 1,7 млн
How To Create An Excel Data Entry Form WITHOUT A UserForm
1:10:51
Try not to Laugh Game!
00:38
Просмотров 4,6 млн