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]

Ясат пт

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

[@iamroie2b]

Great content! How do you protect your database worksheet?

[@thedatalabs]

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

[@Paren_Tattoo93]

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

[@zeweldihaile2718]

You revealed how Microsoft Excel is powerful too in data management, data analysis, and data entry. That is more than I expected to do in Excel. Thank you for your wonderful tutorial, Sir.

[@thedatalabs]

Thanks for your feedback!

[@mconsulting7394]

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

[@omegaunisex]

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

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

[@efftsii]

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

[@kidskona3287]

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

[@arunlaxmanraut]

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

[@venecksfennuelfaivera1925]

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

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

[@michaelhenderson5098]

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

[@anisaputrialiya2023]

1triliun like buat akun ini... terimakasihh banyakkk

[@electricus_aniruddhachanda8184]

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

[@chikabells5296]

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

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

[@jasonpineda8513]

Great video! I found when setting function for save button and after i debug/compile I receive a message stating compile error: Sub or Funtion not defined. My first thought was maybe i misspelled something but I dont see anything spelled incorrectly. What would be some other items to look for to correct this? Tia!

[@thedatalabs]

Thanks for your feedback! Could you please post your code here where you are getting an error. I will check and suggest corrections. Thanks!

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

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

[@PaulBigwood-r1w]

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.

[@pregaramen8747]

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

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

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

[@wesverg658]

Hi, this video is very helpful , I have a question ,similar to your databsae or entry form, say I have 100 product or items and if customer purchase this product, I would like to search the item first and enter the cusomter name and other info before I save it. how to search the certian item on the list of product and hot to the form and entering other s info before I save it. basically I should have a different shet for produ t list and its details (price code etc..) ? thank you for your help..

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

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

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

[@danielmoseskuma7921]

very quick and easy and easy to learn.

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

[@dilboo44]

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

[@UpTop5000]

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

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

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

[@charlesstrickland9007]

Great Job on form! Thanks

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

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

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

[@cobra777888]

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

[@vanessawhite5125]

Thank you so much for the amazing tutorials

[@antonmirador9127]

sir can i ask something can i use more database they will save the data entry

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

[@zackmekintoshcolins6485]

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

[@estherm9102]

Thank you. It works PERFECTLY!

[@jersonagabao8125]

I learned a lot from this video. 😀😀😀

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

[@sahucr]

Very good explanation 👍

[@glennoordwijk]

Hello Dilip, Your video is awesome. But I have a question. See the coding about Validating Department. (time> 39:20) This works when there are only a few options to select. But whatif the the list of options is long (>50) and stored in another sheet (metadata). How do I need to change the code to make it work? thank you for your time

[@lucsaint-onge6323]

Very instructive ! congrats !

[@thedatalabs]

Thanks for your feedback!

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

[@craigmcrobbie5559]

Great sheet, i am learning code and made a database for inventory, the save button and modify work but when i unlock the input cells and protect the sheet i keep getting an error on the first section we coded, how do i fix

[@Damthatjam]

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

[@GG-ts7nj]

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

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

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

[@tecpulsevision3292]

Great, helpful for beginners ...

[@romeolabine200]

Thank you so so much..u just got a new fan here.

[@thedatalabs]

Thanks!

[@HossamElgnainy]

Thank you you, this helped me too much

[@nisarahmed5869]

I was searching such video Great

[@thedatalabs]

Thanks for your feedback!

[@jaelynreese2399]

This is amazing! Thank you so much! I am getting an era “end if without block If” within the validate function. Do you have any idea of how to fix this? Thank u 🙏🏾

[@MsKaran1994]

Type end if command twice

[@akashsiva5555]

It is very nice and easy. Thank You.

[@akashsiva5555]

Yes

[@akashsiva5555]

Yes

[@ayumiyamada9562]

Thank you so much. I learned a lot.

[@haditorkmani2600]

I do not see the developer options in the MAC OS. I added the developer tab in the ribbon, but it does not allow me to change properties on the Group Box which is supposed to be the text box.

[@monaraejenkins3866]

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

[@komenasai86]

hi, want to ask. how to do like, pulling data from one tab(eg; database) to new tab. what i mean is on new tab i got a form with same format as database. so, when i enter number or name in the form on new tab(partially), it will automatic display number or name, and then input all the details from database. this project is for when someone come, i just enter number or name in new form and then it will fills all the details in the form. for new entry just enter details to database. thanks.

[@muhammadirfankhan3265]

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

[@sokhaputh2092]

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

[@thedatalabs]

Thanks!

[@farzanrazick7166]

Very Useful and GOD bless you.....

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

[@virajdesai239]

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

[@varmasknowledgehub5235]

Awesome explanation....👍👍

[@gng.galagar4282]

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

[@pcvictory2889]

Hello I'm Ponlue .I'm come from Cambodia. I have one or two question I downloaded and I can't add entry

[@michaelso3432]

If you want to modify a record then save it as a new instance rather than doing an override function is that possible on the code that we used under the sub save() part

[@thedatalabs]

Yes, you just need to change the iRow variable used to identify the blank or existing row. If you want to save it as new record then use next blank row available in Database. Thanks

[@kendonphua2139]

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

[@thedatalabs]

Thanks!

[@bbsreekumar1]

Excellent tutorial

[@michaelsilva8236]

Good day, I have followed your instructions and cannot seem to get the Modify cmd to work, I always get no record found. Can you assist please?

[@jalalkhezam150]

thanks for the video it's very useful but i would like to ask please for the modify, ist possible pickup the data using the employee id instead the Serial number

[@thedatalabs]

Thanks for your appreciation! Yes, please use the Employee ID in searching the row.

[@jalalkhezam150]

​@@thedatalabs can you just put a formula as sample only so it will be easy for me to encode the rest

[@JosephDanoUrmeneta]

Hi is this possible if i make for our restaurant order automatic this form, thank you

[@sisirasiriwardana5694]

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

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

[@angieburgos7593]

great tutorial thanks! but i cant find the record when I call it, how can i fix this issue

[@chisedelicano492]

Thank you for this! May I know how can the database sheet be protected from manual editing?

[@paoloramirdino5784]

Right click on the database sheet,choose protectsheet then put your desire password on the sheet.

[@samimohd54]

Helo sir, i want to refresh the serial number like auto updating after deleting the record in database...

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

[@elledragneel_spacehub4140]

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

[@davidleaper8653]

Hi there - I am having some trouble with the Sub Save section, in particular the line: irow = database.Range("A" & Application.Rows.Count).End(xlUp).Row + 1 It keeps creating an error - is there any advice you have or can I send my spreadsheet to someone to see what I have done wrong?

[@Ikram5575]

I saw your vedio i am following you step by step and prepare a sheet but i am facing problem at stage of (Developer-Insert-ActiveX control Table) at the time of draw table sheet give me error "cannot insert Object" please advise me

[@naureensharif236]

your video is really good

[@suzannejoshua9836]

Hi, I need help please. How do I save the data in a separate workbook. And the workbook is saved in a shared folder.

[@thedatalabs]

Please watch this tutorial. Thanks! kzbin.info/www/bejne/bH3WhqCpqa-Cjpo

[@marcooliveira9335]

Thanks for this presentation

[@phistoanonymous1798]

This was extremely helpful. Thank you

[@Moizfoodi]

thanks ..... done a great job....

[@fatinsyafiqah393]

Hello, what should I do if I want to replace the serial number to auto refill number instead? Or simply just no serial number.

[@romeodariochiu8137]

Good day Sir. Just wanna ask why it is error in sub delete.... In row Sheets("Database").Cells(iRow,1).Entire Row.Delete shift:'' xlup When I make compilation error showed Variable not defined. Can you teach me to rectify or correct this? Thank you very much.

[@manarsis9628]

hello sir, now that we have finished creating our database, how to protect it from any inadvertent intervention. Thank you for answering me