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 🙏
@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.
@lacpeb3 жыл бұрын
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.
@nokpiadariusconstantino13332 жыл бұрын
Ясат пт
@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!
@Paren_Tattoo93 Жыл бұрын
I always come to this video to learn some coding.. still useful in 2023 tq so much sir..
@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,
@iamroie2b2 жыл бұрын
Great content! How do you protect your database worksheet?
@thedatalabs2 жыл бұрын
Thanks for your feedback! Please watch this tutorial. kzbin.info/www/bejne/n2Knm4Vvj7WWiMU
@mconsulting7394 Жыл бұрын
Thank you! I found all the errors by myself. Perfect experience and study.
@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 🤝
@thedatalabs4 жыл бұрын
Glad to hear that you found this tutorial useful. Thanks! 🤝
@omegaunisex2 жыл бұрын
Awesome!! You are a good teacher. I will keep following you. Good job. Bless you.
@chikabells52962 жыл бұрын
This tutorial I learned a lot of information to start of my projects using macro. Thanks ❤️ Alhamdulilah. More videos please ❤️
@efftsii2 жыл бұрын
Thanks bro. Working on collecting data on a project and your video has helped me to do up a data base.Thanks bro
@nokirikitno2 жыл бұрын
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
@kidskona32872 жыл бұрын
I actually completed the entire one hour plus video, it is very detailed and helps a lot.
@karenbrock23796 ай бұрын
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?
@electricus_aniruddhachanda81842 жыл бұрын
Really excillent table. Grat Sir. The grate thing is hear you did not use any coding
@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...
@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?
@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
@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.
@michaelhenderson50986 ай бұрын
Thank you. This video was very helpful. I was able to create my own data entry for sales.
@sikoraako9 ай бұрын
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.
@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.
@jamiejimenez711111 ай бұрын
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
@pregaramen87472 жыл бұрын
awesome , very helpful and explicit video. Thank you very much sir. from mauritius.
@robwin00727 ай бұрын
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.
@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!
@thedatalabs3 жыл бұрын
Thanks for your feedback!
@PaulBigwood-r1w10 ай бұрын
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?
@thedatalabs10 ай бұрын
Thanks for your feedback! Could you please share the code for Delete? I will check and suggest the changes.
@greatfreeideas7353 күн бұрын
Hello. its Super and veru user friendly. Can i request you to sahre VBA code to delete entire row if a particular cell value entered. For example, I want to delete entire row when I enter emplyee ID, instead serial No? Please help.
@UpTop50003 жыл бұрын
Thank you for this! Can you offer a way to make the sheet tab through the unlocked cells only?
@venecksfennuelfaivera19253 жыл бұрын
This video is awesome. I can now develop database with Excel.
@vijimgowda3 жыл бұрын
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 ??
@arunlaxmanraut2 жыл бұрын
सर माहिती फारच छान आहे फार फार धन्यवाद सर !.......
@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.
@wesverg6583 жыл бұрын
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..
@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!
@jhunbanton74143 жыл бұрын
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
@GG-ts7nj3 жыл бұрын
It's Most Mind Blowing Training for US [ New Students ]
@danielmoseskuma79212 жыл бұрын
very quick and easy and easy to learn.
@FMFT Жыл бұрын
Great job! What about a library management system?
@Damthatjam Жыл бұрын
This tutorial is very well done. Thanks so much for putting in the time to make this. Subscribed for more
@cobra7778882 жыл бұрын
Thanks Brother, it is great. You have explained each and everything clearly. Thankyou So much.
@sisirasiriwardana5694 Жыл бұрын
Thanks a lot for your knowledge sharing. Can you please mention how data set recall by Employee ID (from a dropdown) for modifying?
@sokhaputh20923 жыл бұрын
with my humble respect for your hard work. from Cambodia🙏🙏🙏🙏🙏
@thedatalabs3 жыл бұрын
Thanks!
@vanessawhite51252 жыл бұрын
Thank you so much for the amazing tutorials
@mohit84602 жыл бұрын
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
@varshashounak4 жыл бұрын
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
@juanpablohernandez18903 жыл бұрын
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,
@jasonpineda85139 ай бұрын
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!
@thedatalabs9 ай бұрын
Thanks for your feedback! Could you please post your code here where you are getting an error. I will check and suggest corrections. Thanks!
@rvkrishnan783 ай бұрын
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
@thedatalabs3 ай бұрын
Thanks for your feedback! Please watch the multi user data entry video.
@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.
@africanperspectives93533 жыл бұрын
I enjoyed the first part. Coding is somehow complicated. But you have done an excellent work.
@thedatalabs3 жыл бұрын
Thanks for your feedback! Please subscribe our channel.
@jaelynreese23992 жыл бұрын
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 🙏🏾
@MsKaran19942 жыл бұрын
Type end if command twice
@nkenyirene16112 жыл бұрын
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?
@dilboo443 жыл бұрын
Very useful . Really I have been searching for this life of example.
@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..
@tonitoni93683 жыл бұрын
hello .. thank you very much for the great work ... i have a question: would print it out. can you set it in VBA to show the time and the user in the form? Thanks very much
@estherm9102 Жыл бұрын
Thank you. It works PERFECTLY!
@marcbeideler74442 жыл бұрын
Hello, Great video, Thank you for that. Unfortunately I have a problem with the modify and delete code. I entered it the same way you did and checked now several times, it is identic but doesn't work. Do you have any idea? Thank you
@jeromedaffon5205 Жыл бұрын
really like your tutorial. do you have transcript code of this video? that I can download? thanks Good tutorial.
@deetalks8283 жыл бұрын
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.
@charlesstrickland90072 жыл бұрын
Great Job on form! Thanks
@romeodariochiu81372 жыл бұрын
Good day Sir. I have found out when I make some delete, S. No. doesn't change. Thank you very much.
@Allrounder003842 жыл бұрын
thanks alot, it was helpful. just that after saving, my form doesnt refresh automatically. dont know where i went wrong
@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
@dondonneo112011 ай бұрын
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
@nidhalmahjoubi79642 жыл бұрын
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?
@guest54722 жыл бұрын
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.
@cakchaitanya97822 жыл бұрын
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.
@idahbaa70202 жыл бұрын
Nice. Its so easy to understand. I would like to request tutorial for vba Search button for specific range. (Not No. Serial). Please please
@microsoftsarker2 жыл бұрын
Thanks, Useful tutorial
@angieburgos75932 жыл бұрын
great tutorial thanks! but i cant find the record when I call it, how can i fix this issue
@gng.galagar4282 Жыл бұрын
Thank you so much, I will use in our school.
@akashsiva55553 жыл бұрын
It is very nice and easy. Thank You.
@akashsiva55553 жыл бұрын
Yes
@akashsiva55553 жыл бұрын
Yes
@tecpulsevision32922 жыл бұрын
Great, helpful for beginners ...
@virajdesai2392 жыл бұрын
This is amazing.... Really helped a lot.. THANK YOU!!
@zackmekintoshcolins64853 жыл бұрын
Thank you broder for this tutorial this is a decent tutorial I found here in youtube so far
@odraude8773 Жыл бұрын
very nice and informative, how i wish the audio is a little louder
@phistoanonymous17982 жыл бұрын
This was extremely helpful. Thank you
@Campboundph2 жыл бұрын
This is so Awesome. What if I want to use a different serial like ABC0001 and so on?
@HossamElgnainy3 жыл бұрын
Thank you you, this helped me too much
@dahatyousif97014 жыл бұрын
Great video many thanks, what I want to make a database to enter from a box in sheet1 and save it to a database in sheet2. I followed all your steps and worked well but I cannot find which code exactly was for that when you click on save it saves the data to database and resets the form again.
@kapaunkelo69394 жыл бұрын
This is very useful, Thank you, can you please make one with a multiple databases and search button please
@manarsis96282 жыл бұрын
hello sir, now that we have finished creating our database, how to protect it from any inadvertent intervention. Thank you for answering me
@lucsaint-onge63237 ай бұрын
Very instructive ! congrats !
@thedatalabs7 ай бұрын
Thanks for your feedback!
@ayumiyamada95622 жыл бұрын
Thank you so much. I learned a lot.
@hemantsharma52853 жыл бұрын
Thank you sir great video. please tell Find button coding and also how to add employee photo in form in your next video ..
@sahucr4 жыл бұрын
Very good explanation 👍
@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.
@granand3 жыл бұрын
Thank, I will follow this, please may I know if you can help in using SQL as a backend so that we have better CRUD control
@lalala6223 жыл бұрын
That’s so useful thank you so much !. i want use this, but how can I use and change this for my form?????? the first two cells Dependent By each other and using comobox , How can I change your code in my form and keep it working right ? ? ?
@farzanrazick71663 жыл бұрын
Very Useful and GOD bless you.....
@ItsFunky194 жыл бұрын
Thanks Bro This is great Tutorial ...I have question is possible instead on using the ID / number as search criteria .. can we set it to search for a text?
@juanvasquez32353 жыл бұрын
Well done! This tutorial was easy to follow along and apply to day to day functions.
@renjithxavier28914 жыл бұрын
Great video ....I need to know more about the codes and uses of codes
@thedatalabs4 жыл бұрын
Thanks for your appreciation! Please keep watching. We will publish advanced VBA form. It will help you in improving the VBA Skills.
@renjithxavier28914 жыл бұрын
@@thedatalabs can u please share the link for the startup
@lescooper3893 жыл бұрын
Very very good.Just what I needed. However is there a way of showing ID’s instead of possibly guessing them or indeed insert a search command button.
@kendonphua21398 ай бұрын
I am new subscriber, i folled your steps and ive got it. Thank you
@thedatalabs8 ай бұрын
Thanks!
@JosephDanoUrmeneta3 жыл бұрын
Hi is this possible if i make for our restaurant order automatic this form, thank you
@elledragneel_spacehub41403 жыл бұрын
Hi Sir, thanks for sharing information. You are great at teaching. I hope many people can learn through your videos.