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 🙏
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.
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.
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,
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.
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 🤝
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...
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.
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!
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.
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.
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.
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.
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 UA-cam channel. 🙏🙏🙏
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..
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
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
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
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?
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?
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
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 🙏
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.
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.
Ясат пт
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,
I always come to this video to learn some coding.. still useful in 2023 tq so much sir..
Thank you! I found all the errors by myself. Perfect experience and study.
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.
Thanks for your feedback!
Awesome!! You are a good teacher. I will keep following you. Good job. Bless you.
सर माहिती फारच छान आहे
फार फार धन्यवाद सर !.......
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 🤝
Glad to hear that you found this tutorial useful. Thanks! 🤝
This video is awesome. I can now develop database with Excel.
This tutorial I learned a lot of information to start of my projects using macro. Thanks ❤️ Alhamdulilah. More videos please ❤️
I actually completed the entire one hour plus video, it is very detailed and helps a lot.
awesome , very helpful and explicit video. Thank you very much sir. from mauritius.
It's Most Mind Blowing Training for US [ New Students ]
Thanks bro. Working on collecting data on a project and your video has helped me to do up a data base.Thanks bro
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...
Really excillent table. Grat Sir. The grate thing is hear you did not use any coding
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.
Thank you. This video was very helpful. I was able to create my own data entry for sales.
Very useful . Really I have been searching for this life of example.
I learned a lot from this video. 😀😀😀
Make my excel life easy..
#Thank you
#Subscribed
Thanks Brother, it is great. You have explained each and everything clearly. Thankyou So much.
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!
Thanks for your feedback!
Thank you. It works PERFECTLY!
very quick and easy and easy to learn.
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.
with my humble respect for your hard work. from Cambodia🙏🙏🙏🙏🙏
Thanks!
I was searching such video
Great
Thanks for your feedback!
Thank you broder for this tutorial this is a decent tutorial I found here in youtube so far
I enjoyed the first part. Coding is somehow complicated. But you have done an excellent work.
Thanks for your feedback! Please subscribe our channel.
This tutorial is very well done. Thanks so much for putting in the time to make this. Subscribed for more
This is amazing.... Really helped a lot.. THANK YOU!!
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!
Thank you so much for the amazing tutorials
Very useful and simple. easy to catch step by step due to slow motion in teaching. good work keep it up
Thanks for your feedback!
@@thedatalabs
Error
Please share the line of code where you are getting the error. Thanks!
Very good explanation 👍
I am new subscriber, i folled your steps and ive got it. Thank you
Thanks!
Thank you so so much..u just got a new fan here.
Thanks!
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.
It is very nice and easy. Thank You.
Yes
Yes
Great content! How do you protect your database worksheet?
Thanks for your feedback! Please watch this tutorial.
ua-cam.com/video/i1DjR9ZPcRc/v-deo.html
Very instructive !
congrats !
Thanks for your feedback!
Genius!!! Thanks for teaching this process!!!!!
1triliun like buat akun ini... terimakasihh banyakkk
Thank you you, this helped me too much
Great, helpful for beginners ...
This was extremely helpful. Thank you
Very Useful and GOD bless you.....
Best tutorial in youtube 💕💕💕💕💕💕💕
Great Job on form! Thanks
Hi Sir, thanks for sharing information. You are great at teaching. I hope many people can learn through your videos.
Thank you Mr Kamur you did an excellent presentation
Thanks for this! Well written and very helpful
Sir your works are very educative and helpful.
Thanks a lot for the informative videos which have been very handy.
Fantastic thankful for for your help supplying full details clear enough
Thank you so much. I learned a lot.
Well done! This tutorial was easy to follow along and apply to day to day functions.
Very good❤ thank you so much
Thanks for your feedback!
Thank you very much for this great content. A huge help for me..
Liked the way you delivered and explained the entry data . Loved it and subscribed. Well done!
Wow Thank you very much u made my day brother keep it up kindly i need the Payroll tutorial please 🙏
very nice and informative, how i wish the audio is a little louder
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.
This tutorial was awesome and it helped me and fulfilled by purpose of building a form for business use :) Thanks a lot .
Thanks for your appreciation!
Цдддд кдтуузаээагшри
Цдддд кдтуузаээагшри
Very helpful and good way to explain.Keep it up man👍
Glad it helped, thanks!
Awesome explanation....👍👍
thank you so much for this awesome tutorial n too much love and respect for you
Thanks for your feedback!
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.
Very good your Excel and VBA , Thank you sir
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 UA-cam channel.
🙏🙏🙏
Good video🥀🌹
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
your video is really good
Good and great , excellent clear explanation, super sir, thanks to u
Thanks for your feedback!
Neatly demonstrated
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?
Excellent tutorial
Thanks for this presentation
Thank you so much, I will use in our school.
Thank you very much. This is very very helpful. I did my first Macro and would like to more, please support with more videos
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..
This is very useful, Thank you, can you please make one with a multiple databases and search button please
So useful and such clear explanations. I am really glad I discovered this. I have added it to Favourites.
Thanks Sir! i want to learn user form and Active X Control tools. U r really expert.🙏😍
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
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
Thanks for your feedback! Please watch the multi user data entry video.
Nice. Its so easy to understand. I would like to request tutorial for vba Search button for specific range. (Not No. Serial). Please please
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
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?
Good day Sir. I have found out when I make some delete, S. No. doesn't change. Thank you very much.
thanks ..... done a great job....
Thank you for this tutorial very helpful.
I hope for the next video, about the addition, subtraction, division and multiplication.
Thanks for your feedback! Please share your idea on our email id. Thanks!
Has this been created?
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 👍
Very informative and helpful. Thanks.
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.
Thank you sir great video. please tell Find button coding and also how to add employee photo in form in your next video
..
Thats good and need keep it up also support
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?
Thanks for your feedback!
Could you please share the code for Delete? I will check and suggest the changes.