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

[@Leo-sm7ci]

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]

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]

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.

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

[@nokpiadariusconstantino1333]

Ясат пт

[@Paren_Tattoo93]

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

[@davidsumner397]

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,

[@iuhshwth1634]

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]

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

[@mconsulting7394]

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

[@deetalks828]

Hi. I'm new to VBA and I'm not really an advance user of excel. I find your tutorial very helpful. I followed it and I was really feeling good because every single time I clicked on Debug, there were no errors. But as I was customizing it towards the end of your video where you said to double click on SAVE, I got errors. I hope you can help me customize my own report. Hope to hear from you soon.

[@robwin0072]

Hello, I have watched your Excel videos on userforms with VBA and found them very helpful. Do you have a video demonstrating userforms with VBA to create an income and expense tracker? That also Adds, Delete, and Modify entries. The video doesn't have to show a dashboard worksheet that tracks income and expenses and calculates the difference unless you want to. Also, the userform should be able to track the category of the income and the cost, which are essential for a profit and loss statement. Thank you so much for all you do on your KZbin channel. 🙏🙏🙏

[@sikoraako]

this video is exactly what i have been wanting after a great deal of searches. thank you for doing this. my only problem is i am using the excel 365 using mac air and the function are very limited. For one, there is no user form in vba and this is why your videos are very helpful to me. Second, there are no activeX controls. Please show me tips on how to go around these activeX controls. Any help is appreciated.

[@noor.3385]

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.

[@electricus_aniruddhachanda8184]

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

[@omegaunisex]

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

[@michaelhenderson5098]

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

[@simpleerlyn3899]

This is my first time to create data entry form. It is very useful and easy to follow the tutorial. Please help me how to modifying typing a Name of employee? Thank you so much..

[@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]

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.

[@jamiejimenez7111]

This tutorial is awesome. I have the same requirements except i need to add on the log in and log out field. Which im having error in validating portion. Hope you could help

[@efftsii]

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

[@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!

[@thedatalabs]

Thanks for your feedback!

[@kidskona3287]

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

[@karenbrock2379]

Thank you for the most informative demonstration I have watched thus far from about 30 videos. I am a little stuck though on the Data Validation. I am having debug issues with all code relating to the message box?

[@worasakwongprakornkul8126]

Thank you very much for your fruitful tutorial. I have a question: in case I have deleted one record, the serial number will be repeated or not? What I understand is that the next s.no. is created by counting number of rows recorded. As your example you have s.no.1,2,3 and 1 is deleted, no. of row is reduced, so the next no. will be 3 repeated to the existing record. If I am correct, kindly let me know how to solve it. Thank you very much.

[@GG-ts7nj]

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

[@githeshs5905]

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.

[@chikabells5296]

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

[@rvkrishnan78]

Thanks for the wonderful guidance, i developed a same Macro with different Form, it is working fine. one doubt i could not share this File , where multiple can access this at a time

[@thedatalabs]

Thanks for your feedback! Please watch the multi user data entry video.

[@pregaramen8747]

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

[@romeodariochiu8137]

Good day Sir. I have found out when I make some delete, S. No. doesn't change. Thank you very much.

[@arunlaxmanraut]

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

[@cakchaitanya9782]

Excellent!!! Sir, request you to please ...please ..modify this coding with Print command button so that any wants to print the record details in an excel sheet , the same cans be done from the menu.

[@benvanmaanen7059]

Hi Have created form as per your video very informative thank you. I have unlocked the data entry cells and protected the worksheet. When I hit the save button the validate macro stops at the following line ".Range("H6").Interior.Color = xlNone" I have no knowledge of VBA and just follow tutorials. Any suggestions as to fix this issue. Thanks.

[@kasimselamat7129]

Very2 good tutorial sir.. May i add time stamp to help me revise? 1)validation 27:55 2) reset 45:10 3)modify 58:15 4)save 1:12:30

[@juanpablohernandez1890]

This is great!!. I enter my information on my form and when I save it and go to the Database to see it it only shows False ,false, across my columns. can you help me? Thanks,

[@venecksfennuelfaivera1925]

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

[@nkenyirene1611]

Waoo waoo This is simply awesome. Can you please add how we can protect these sheets so that they cannot be modified and be used justbto collect data?

[@sokhaputh2092]

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

[@thedatalabs]

Thanks!

[@dondonneo1120]

good morning sir, i am a follower and subscriber. i followed this video of yours and tried to create an entry and it was working good. the only trouble i encountered is everytime i modify and save a record, it save on next row not on the current row which i modified. hope you can help me about this

[@user-hu8rh5mb4n]

Hi Dilip, Thanks for this. Very useful learnt a lot. I have a problem though. When i press Delete button Excel puts up a message hox saying This will delete the entire sheet do you want to proceed? This is as soon as i press the Delete button . i am not asked for the serial number to delete? I am using Microsoft 365 Excel. latest version . Any ideas?

[@thedatalabs]

Thanks for your feedback! Could you please share the code for Delete? I will check and suggest the changes.

[@UpTop5000]

Thank you for this! Can you offer a way to make the sheet tab through the unlocked cells only?

[@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!

[@PCCInternationalStudentC-tz2vn]

thank you. this is very helpful. I have a question: I created a field for email. After i click "SUBMIT" all fields clears out except the email field. How can i change that?

[@zackmekintoshcolins6485]

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

[@kapaunkelo6939]

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

[@mohit8460]

Hello sir, it's really helpful to me in my office thanks for this but i need a very important concern that lock the excel sheet then this VBA doesn't work please give suggestions how to even lock the excel while working

[@nokirikitno]

Awesome tutorial! Thnak you having refresh from programming after a long while... but can you help me debug, when i get to protection the sheet (form) it wont work. looking forward to your assistance. Thank you

[@cobra777888]

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

[@africanperspectives9353]

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

[@thedatalabs]

Thanks for your feedback! Please subscribe our channel.

[@monicaramento6678]

Im not an IT major. But so interested with your videos cause im trying to create simple form and database tru excel. I just want to know wether i could modify the data through employee ID? Or is it fixed to use serial number only? Please answer me...♥️

[@danielmoseskuma7921]

very quick and easy and easy to learn.

[@blvckpineapple]

This is really helpful. But do you have a video for mac users. I understand it completely. But I use a mac and finding some of the commands is a bit troublesome

[@sisirasiriwardana5694]

Thanks a lot for your knowledge sharing. Can you please mention how data set recall by Employee ID (from a dropdown) for modifying?

[@elledragneel_spacehub4140]

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

[@renjithxavier2891]

Great video ....I need to know more about the codes and uses of codes

[@thedatalabs]

Thanks for your appreciation! Please keep watching. We will publish advanced VBA form. It will help you in improving the VBA Skills.

[@renjithxavier2891]

@@thedatalabs can u please share the link for the startup

[@idahbaa7020]

Nice. Its so easy to understand. I would like to request tutorial for vba Search button for specific range. (Not No. Serial). Please please

[@jersonagabao8125]

I learned a lot from this video. 😀😀😀

[@jeganathanbalaraman1235]

It was very useful. But im looking for additional criteria, Make database as readonly sheet with filter in header column

[@triplextm4703]

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]

Hello, I'm facing the same issue. Did you find a solution?

[@ramngaihzuala3212]

This video is awesome... I learnt alot from this video.. one question..how to search by two criteria ? Example.. search by ID and names and return the data if the input match by name and ID.. I hope you understand my question...

[@dilboo44]

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

[@jhunbanton7414]

Nice and very easy to follow, Can you help to fix my project I am searching for the tutorial that fit in my requirement. Thanks

[@gng.galagar4282]

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

[@Allrounder00384]

thanks alot, it was helpful. just that after saving, my form doesnt refresh automatically. dont know where i went wrong

[@tongallegos2680]

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 👍

[@anisaputrialiya2023]

1triliun like buat akun ini... terimakasihh banyakkk

[@hexadx]

Hello first of all, thank you this was incredible tutorial and helped me learn a bunch of new things, but at the final part it seems to be giving me this error: Run-time error '438': Object doesn't support this property or method. When pressing the debug button it highlights the row: iRow = frm.Range("L1").Validation

[@hexadx]

Nvm it seems I just had autofilled a wrong thing it was supposed to be Value not Validation!

[@juanvasquez3235]

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

[@vanessawhite5125]

Thank you so much for the amazing tutorials

[@praveenkumarshetty6503]

This is very good but very difficult for beginners

[@samsundersagayanathan8192]

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

[@bakarazad7078]

Hi sir, I would like to ask, after delete a data, there serial num still the same. Could you show how to change the serial num change and follow sequence after deleting any data?

[@lhendupgyeltshen3568]

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

[@thedatalabs]

Thanks for your feedback!

[@yami-me5ox]

@@thedatalabs Error

[@thedatalabs]

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

[@aamd6657]

Good afternoon, I have just gone through your excellent tutorial and everything works except the delete record section. I have double checked everything and I cannot work out what is happening, but the form sheet gets deleted everytime instead of the single line of data. Do you have any suggestions? I even went tothe website and checked the code line for line. Puzzled!

[@justpeople5008]

Same here haha

[@thedatalabs]

Could you please post the delete sub procedure here? I will check and get back to you. Thanks!

[@aamd6657]

@@thedatalabs thanks for getting back to me, I resaved the spreadsheet, then closed it down, restarted the computer and it worked fine...... very strange! thank you

[@kcchu3960]

Thanks for the tutorial. I have tried the full set of these code. It is inspiring. However, the "Save" function is no longer working after deleting the middle rows via the "delete" function. I think the main reason is due to the discrete of the iSerial after delete, but i have no idea how to fix it. Thanks.

[@mehoahmic]

Excellent tutorial, as someone that never did VBA, i managed to create data entry form that will help me. I have just one question, is there any way to run data entry forms on Android devices - basic data entry form with 4 data input.

[@thedatalabs]

Thanks for your appreciation! Unfortunately, Android doesn't support VBA as of now. Will let you know if I will find any alternate way to automate Excel on Android platform. Thanks!

[@kendonphua2139]

I am new subscriber, i folled your steps and ive got it. Thank you

[@thedatalabs]

Thanks!

[@caloyskingespiritu5719]

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

[@hemantsharma5285]

Thank you sir great video. please tell Find button coding and also how to add employee photo in form in your next video ..

[@Damthatjam]

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

[@rubylosbanos4358]

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.

[@monaraejenkins3866]

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

[@teslateb1545]

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

[@estherm9102]

Thank you. It works PERFECTLY!

[@mommak5691]

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.

[@yinthuaung9838]

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

[@muhammadirfankhan3265]

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

[@htablet6424]

Save data is good but edit records by name search box dynamic it is necessary not serial number if name search edit setting it very good

[@haidsyacob7154]

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

[@thedatalabs]

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

[@danthedeekzfan]

Has this been created?

[@nidhalmahjoubi7964]

Thanks for this great tutorial... I have one question! I didn't understand why did you pick Cell M1 and L1 to store serial number and data. Do we pick any empty rows?

[@varshashounak]

thanks a lot, I have created a rough database for my society, however, not yet finalised. Just have a query with regards to serial numbers on database. As and when we delete the records, it just delete that particular row. the next serial number shifts up and this disturbs the serial number sequence. can you please help me on this i.e. how we can change the serial numbers too... thanks

[@virajdesai239]

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

[@odraude8773]

very nice and informative, how i wish the audio is a little louder

[@vijimgowda]

great one , I had question , if you want to delete by searching name or any string with name and numeric value , what to I add in inputbox prompt ??

[@akashsiva5555]

It is very nice and easy. Thank You.

[@akashsiva5555]

Yes

[@akashsiva5555]

Yes

[@nisarahmed5869]

I was searching such video Great

[@thedatalabs]

Thanks for your feedback!

[@iamroie2b]

Great content! How do you protect your database worksheet?

[@thedatalabs]

Thanks for your feedback! Please watch this tutorial. kzbin.info/www/bejne/n2Knm4Vvj7WWiMU

[@AnilSingh-yt7ci]

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

[@simeat7453]

just getting started

[@ruginathomas3873]

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

[@guest5472]

Do you have a sample of a note template? Almost similar to this but no need to save, just need copy and reset function.. most likely used for customer service call notes.