Please watch the Complete Tutorials (Part 1, 2, 3,4 and 5) of creating Fully Automated Data Entry Form in Excel. Part 1 (UI Design, Transfer and Reset) - ua-cam.com/video/P53T6oxgUVA/v-deo.html Part 2 (Edit and Delete) - ua-cam.com/video/K1d4JpuLkqE/v-deo.html Part 3 (Search and Filter) - ua-cam.com/video/BdEMj4NNXAE/v-deo.html Part 4 (Validate and Print) -ua-cam.com/video/0bFOKpaSIBg/v-deo.html Part 5 (Full Screen, Zoom and Dynamic Drop-down) - ua-cam.com/video/f7W3HRLQYAs/v-deo.html
Hi, I am using now the same program you made in your tutorial... and I am thankful to have this kind of vba program through your initiative. It is very nice and I learned many things in your tutorial from Part 1 to Part 5. Now. I would like to ask you a favor if you could add vba codes for having three (3) option buttons to add in the "Gender" portion, like adding one more option button. Thank you.
#thedatalabs i have watched all the tutorial completely omg you're amazing and i start using this tutorial for work its awesome thanks a million..i like, subscribe and share.
Dear, your video is an amazing tutorial. My last programming was 15 years ago and I needed to create a full Entry Form for my friend for his work. Just with watching your video, I remember something from my old programming knowledge also and managed to create a wonderful form and automated excel file with all required details. Appreciated your time to post this video.
I have never used VB with Excel but only with Access Database. Now, I have found this tutorial to be an excellent tool to help my colleagues with data entry.
This is really very simple yet effective userform which one may use to elaborate/customize ones own userform as per the requirements. Integration of the Grid control is really an added bonus. Great work buddy!
I like these tutorials, they certainly gave me ideas for how I could improve my own userforms. However, one minor issue/suggestion: At 26:20 you should really consider making the ID dynamic, since you are using this ID in your next tutorials, and deleting one entry will break the ID sequence, causing subsequent misbehaviour when editing, adding or deleting additional entries. I am by no means a VBA expert, and there are probably more elegant solutions to this, but a simple fix would for example be: .Cells(iRow, 1) = "=ROW()-1" EDIT: Sorry, I see you already addressed this in part 4, but since dynamic ID/serial number is required for proper functionality in part 2 (Edit/Delete-buttons), it should have been included in part 2 of these tutorials, or even from the beginning (part 1).
Tx for this very detailed and informative video. In short I'm wanting to get my monthly expense budget and income which I recorded on excel using a few sheets with 1st a data input sheet and 2nd a combined sheet using vlookup's and if_commands to compile a one-pager and 3rd a sheet with lookup's to use as as unique dropdowns in my data input sheet and 4th a pivot from my data input sheet to calculate etc. My issue here is that doing it this way it is very manual and with time a lot of data so IN ALL I tried this automated data entry form as per your tutorial without any coding experience and to my surprise my first input page worked 100%, thank you. Still a long way to get all functions I need but I have subscribed and will do all your tutorials and sure I will find answers for all my requirements.
Okay, first of all, excellent and thorough video/explanation. Now something personal. I am an American with an Indian spritual teacher who is Bengali (what is now Bengladesh), and as part of his dialog, he would always inject a little "...right" as he spoke. He was very dear to me. He passed away in 2007. I am sure you realize that you do this little vocal habit also. I am guessing you are Bengali, but regardless, just listening has given me so much joy! Thank you.
I recently discovered your tutorials on UA-cam and I am truly impressed by the simplicity and accuracy of all of your videos. The presenter is very knowledgeable, humble and has an eye to catch and debug errors. Your videos have helped me greatly! I was hoping that you could help me with a very small question, and will try to explain the problem statement as accurately as possible.. In your user form, you are taking input from the record and storing in the database in each row. I have to create a database where there are default 4-6 rows for each entry with a YES/NO. Example of how the input form would look like (with radio buttons for Y/N in Capability section) - --------------------------------------------------------- Widget Supplier Name : ABC (freeform) -------- Capability 1 | Capability 2 | Capability 3 Widget 1 : Y | N | Y Widget 2 : Y | Y | Y Widget 3 : Y | N | N Widget 4 : Y | N | Y -------------------------------------------------------- Expected result in Database should look like this - Widget Supplier Name | Widget Name | Capability 1 | Capability 2 | Capability 3 | ABC | Widget 1 | Y | N | Y | ABC | Widget 2 | Y | Y | Y | ABC | Widget 3 | Y | N | N | ABC | Widget 4 | Y | N | Y | Can you please help me with this? How should the code be modified?
I have to share, my complete appreciation for this. I have never EVER done this type of thing before, and now I have a working form!! SUPER EXCITED!! THANK YOU!!!
WOWOW! This course was presented so well! BRILLIANT! Even someone Iike me at the amateur level can follow this lesson. Most importantly, after studying all parts in the links below, the results are a sophisticated design which includes macros VBA. It is IMMEDIATELY APPLICABLE FOR PRACTICABLE USE.
Wow! Thank you so very much! Your tutorial is so easy to follow. I was able to create my first VBA Form ever! I was able to also debug all the errors and get the form working! This is my first attempt at writing a code. Thanks very much!
Hi Data Lab's Am receiving an error "could not set the RowSource property. Invalid property value." When I click Debug it tells me error is encountered under Sub Show_Form. How can I correctly that? Your help with be greatly appreciated.
Fantastic training tutorial !!! Very simple and easy to follow along, clear instructions! The video setup, music, etc is also well made! I have now subscribed and I look forward to see other instructional videos. Thank you and God bless you and your family!
@@thedatalabs sir I have face a small problem that when I have fill all details and click the submit button then all fields are empty but which are create database list box are not show data I feel one error in my software that when I update the tabIndex number are 10 then show error It is also show -1 What's this solution
Thanks so much for this - very easy to follow and I have been able to customize it for my own application. I am having one issue, and that is that the database display on the form is only showing the first record entered. I can't find anything that is different from your demonstration. Do you have any idea what I might have got wrong? Thanks
Thank you very much for this video. I followed your steps carefully. I'm so happy I did it! I used it to encode the items we are getting from our cleaning supplies at home to keep track. very useful.
What a lovely video. The form works as expected, and I was even able to make some alterations here and there without compromising its integrity. I appreciate this. Thank you.
Do any of your videos provide coded examples of combo box objects with pull down list values derived directly from a worksheet table? It would greatly reduce the need for VBA skill level support if I didn't have to update VBA code every time a new LOV entry was required by a user. Ideally, as LOV entries are entered into a worksheet table, the form's combo box drop down LOV's should change in synch with the worksheet table. Is this possible? Do you have working examples of this code to share?
Hi this is brilliant! However when i click the launch form at the beginning it stops working and frmForm.Show highlighted with yellow. How to solve this one? Thanks
This is awesome. I have just discovered this tutorial on UA-cam. I am happy I did. Please do you already have tutorial to edit or delete record? I will appreciate if you can provide it. Well done. Great work
Hi, I am using now the same program you made in your tutorial... and I am thankful to have this kind of vba program through your initiative. It is very nice and I learned many things in your tutorial from Part 1 to Part 5. Now. I would like to ask you a favor if you could add vba codes for having three (3) option buttons to add in the "Gender" portion, like adding one more option button for undecided. Thank you.
In writing the codes, kindly explain first the logic and sequence of your approach and from there you breakdown your sequence then you translate to writing codes that will make you more a good teacher.
I am having an issue getting my form to display, when I try and open the form I get an error message number13 when I click Debug it highlights "frmForm.Show". Do you know how I am able to fix this, please? This subprocedure is the procedure that should launch the form. I hope your able to help me, I have been trying for two hours to work out what's happening. Thank you for providing such an informative video.
Thank you very for the tutorial. But when i wanted to run i had this message "Run time error '13' , Type Mismatch". And also FrmForm.Show was in yellow colour .Please help me. Thank you
Really Loved your Video. I have no background of Computer Programming, yet have interest in Excel, and I'm re-watching your Video, this time I guess I've learnt something New. Thanks a Lot sir for creating such a nice informative videos. Really Hats off to you Sir, how you explained things in this Video have become really easy to learn.... Once again, Thanks a lot Sir.... I'm working on my own utility for Stock and Invoice, I would like to share my work, once it is completed....
@@ayushjoshi1685 मला धान्य साठी h2 तयार कारण्यासाठी step by step userform म्हणजे धाण्याचा प्रकार प्राधान्य तांदूळ 10.75विंटल *230दर =2467.90किती वजा होऊन 10=2457.90 जादा व कमी असा fromet बाबत व्हिडीओ दयावा
@@Shashikant-kq1el Too bad. But I saw in the movie exactly at 15:30 that he fills in '10' as value behind 'TabIndex' but that it immediately changes back to '0' as soon as he clicks out of the screen. You have to watch very close because it all happens very fast. So I think that it isn't a problem because the form works at the end! Thank you for replying anyways! :D Have a nice day!
Thanks from pakistan. I copy past you work on excel 2019. Result on second form is not same. It shows only first line or first recording. Question is, how can i fix it?
Most welcome brother! Please download the Excel file from the same link. It will help you in understanding the code and issue. Let us know if you face any issues. Thanks!
you can replace the following code in Submit () iRow = [Counta(datasheet!A:A)] + 1 into iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row 'Find the last non-blank cell in column A
@@georgelaghmjian4367 hello im getting an error with ws its telling me "Variable not defined" im new to this is there some chance you could help please
I make good income too from bitcoin trading and its been my most reliable source of income at the moment. With profits I've made so far I don't think i can get broke or lack anything.
Hello. Unfortunatelly the "Submitted on" does not work for me. I have "#value" in that cell. Not sure what I inserted incorrectly. EDIT: Got it. My mistake.
Perhaps Americans like myself who find Hindi English extremely difficult to understand. They speak too fast and words blend into each other. Sometimes the words sound like a foreign language. This is why I will click out because it is not fun to learn like this.
@@andrusaren8348 definitely the wrong channel for you me and countless others who can’t understand this fast spoken incomprehensible English. He keeps getting clicks and making money off content that isn’t suitable for all. He should tag his content “Hindi English”
type mismatch in the " sub show form" code. Edit: i make it work by editing the source code that this genius man provide it to us for free. I can't thank you enough Sir. keep the good work.
Super helpful....had to play around with the cmb box to get it work.....this example when reopened doesn't show the selections unless I pressed reset. I had to put them above the "show form" line in the last sub prog
Wow..you are a very patient teacher/tutor. Your explanations are so easy to understand. I'm learning quiet a lot from your presentations although I am starting to use Excel. Its so exciting and I love learning from you. Thanks so much all the way here from Papua New Guinea.
Awsome video, thank you very much. I just have 1 question, I need my database to be shown backwards, the last service has to be shown on top, how can I program this.
Thanks for your feedback! To do that you need to change the logic in identifying the next blank row. Please keep the iRow as 2 and insert a blank row after the Column Headers and then update the data. In this way, your previous data will be shifted below.
I love you, my dear Indian friend. Your direct and easy explanation has made my life better. I was able to complete a homework related to this topic. I hope you have an amazing day!
Thank you very much for this series! Please help me with this message after 15:27 in my PC (The macros in this project are disable. Please refer to the online help or documentation of the host application to determine how to enable macros.)
Good morning sir I have seen today 3 videos on the same matter. Though those are in different format, I feel that your work is wonderful, as it is the form what I want the type. Regarding, adding some more buttons/ features like Edit, Deleat, I request to add few more buttons like i) Search for name / Emp. Number, 2) Do you find what do you want Y/N, 3) Do you want enter some more details, 4) Entered by. Thanking you sir- Y/F, Velmula Krishna Rao.
Thanks for your feedback! If I am not wrong then Scrollbars will be automatically added to the VBA listbox if the space is not enough to show all the columns. Let me know if you are unable to see when column length gets exceeded.
@@thedatalabs well noted. Could you please show me how to skip a field (textbox or date picker) if a previous one met a condition? For example if the order was not delivered, skip the date of receipt. Thank you!
Thank you very much. You teaching in detail everything. I know VB 6 very well but I didn't know the VBA procedure. Now I can work with this thanks a lot
This is useful. Thanks. Can I add a button to "print" and "print" will go through the database and print 5 google documents for each record, customizing the first line of each document with the first and last name that's in the database ? Is it possible to work google sheets and docs together like that ? Thanks
Thank you for the amazing tutorials. Can I ask u why if I store data on spreadsheet everything is fine, but if I try to create a table apparently the form doesn’t connect to the sheet and I have a run time error?
Completely new to this, so i'm creating as i watch, im on min 23:47 when he hits debug, however when i do that, an error message pops up that says Compile error: Method or data member not found and the highlighted section lists ".lstDatabase" im sure im missing something, because I had an error message show up earlier and i was able to correct it because it doesn't appear anymore. any help would be appreciated.
Proper coverage of topic which was point to point . Only would request to also include brief explanations of what you are using throughout,, eg., How does "With" works, What is "With" used in vba code, etc. to get idea instantly about them
Thanks for this amazing video, how do i handle a situation where I have a lot of input boxes about 50 of them? What is your suggestion on how to arrange the text boxes in a clean way
Thank you so much for the great Video! I have a question: what if the department entry has one text option: for example: HR, sales, marketing, other: . How do we code for that? Thank u
Hi. Thanks for this tutorial. It does helps me a lot. Would you mind to show, how the database can appeared in reverse order, meantd the latest to appeared at the top of the database?
@@thedatalabs Hi. I just tried this link using the layout from the video above (current video) and can't get it to work. Can you please layout the code here so we can insert it? Thanks and GREAT videos!! Very Useful!
Hi, Thank you for the video. I am looking to create a Userform in Excel 2016 on a Mac but unfortunately the form feature is not present in Excel 2016 on Mac. Is there any other alternative to this?
Years ago i made data entry user form in Word. My job was to fill some standard contracts with data. Different peoples names, two copies etc etc. After that they fired me :D I automated things. Covernment job you know. I filled contracts faster than anybody at that time and without errors. With Vbscript help of course.
Hello, thank you for the viewo, its super informative. Can you help in making the form multi user, i.e., can multiple pple input data in the same form?
Very well explained, thank you so much.....I would like to know how can i find the music you play on the background I notice that it improve my attention span.
Hi your video is amazing! very helpful , I'd like to know if you have video for deleting , updating or modifying (search the data first then update) , also if possible to search certain data via text. I have 100 product and from time to time we update it details like price and we save it or duplicate it but with different product code.. thank you very much
Thanks for your appreciation! This series has total 5 parts. It covers all the functionalities e.g. edit, searc, delete, validate, print etc. I would recommend you to watch all the parts and let us know if you have any question. Thanks!
Great Tutorial! Thanks Dilip! I need to create a simple entry form for 6 fields and I am trying to control the progess of filling in a way that the user can not move to the following field until the value is correct. I am using the event private sub fieldname_exit(ByVal CancelAs MsForms.returnbolean) to validate the input value... however in can not retain the cursor in the field when the value is wrong as it jumps to the following field even when I include in the code the sentence formname.fieldname.focus pointing to the field with the wrong value. Could you please give me some hints to do it? Many thanks and congratulations for your great tutorials.
Please watch the Complete Tutorials (Part 1, 2, 3,4 and 5) of creating Fully Automated Data Entry Form in Excel.
Part 1 (UI Design, Transfer and Reset) - ua-cam.com/video/P53T6oxgUVA/v-deo.html
Part 2 (Edit and Delete) - ua-cam.com/video/K1d4JpuLkqE/v-deo.html
Part 3 (Search and Filter) - ua-cam.com/video/BdEMj4NNXAE/v-deo.html
Part 4 (Validate and Print) -ua-cam.com/video/0bFOKpaSIBg/v-deo.html
Part 5 (Full Screen, Zoom and Dynamic Drop-down) - ua-cam.com/video/f7W3HRLQYAs/v-deo.html
Thanks a million!
I saw this complete video did not see about data duplication check
Hi, I am using now the same program you made in your tutorial... and I am thankful to have this kind of vba program through your initiative. It is very nice and I learned many things in your tutorial from Part 1 to Part 5. Now. I would like to ask you a favor if you could add vba codes for having three (3) option buttons to add in the "Gender" portion,
like adding one more option button. Thank you.
#thedatalabs i have watched all the tutorial completely omg you're amazing and i start using this tutorial for work its awesome thanks a million..i like, subscribe and share.
Hello freind it is relly very usful video can you please add if we want to upload attach and add link
Thanks
Finally, someone who shows me exactly what I need in simple terms.
Dear, your video is an amazing tutorial.
My last programming was 15 years ago and I needed to create a full Entry Form for my friend for his work. Just with watching your video, I remember something from my old programming knowledge also and managed to create a wonderful form and automated excel file with all required details. Appreciated your time to post this video.
One of the best VBA form tutorials i have come across. Thank you
I have never used VB with Excel but only with Access Database.
Now, I have found this tutorial to be an excellent tool to help my colleagues with data entry.
Glad to know you found it useful. Thanks!
This is really very simple yet effective userform which one may use to elaborate/customize ones own userform as per the requirements. Integration of the Grid control is really an added bonus. Great work buddy!
Please add image in this database
I like these tutorials, they certainly gave me ideas for how I could improve my own userforms.
However, one minor issue/suggestion:
At 26:20 you should really consider making the ID dynamic, since you are using this ID in your next tutorials, and deleting one entry will break the ID sequence, causing subsequent misbehaviour when editing, adding or deleting additional entries. I am by no means a VBA expert, and there are probably more elegant solutions to this, but a simple fix would for example be:
.Cells(iRow, 1) = "=ROW()-1"
EDIT: Sorry, I see you already addressed this in part 4, but since dynamic ID/serial number is required for proper functionality in part 2 (Edit/Delete-buttons), it should have been included in part 2 of these tutorials, or even from the beginning (part 1).
may i ask if where does "Value: came from? i tried to copy the code but can't compile and it said method or data not found
Awesome! I never worked on VBA but after watching this tutorial I developed a fully functional Form. Thanks a lot!
Thanks for watching and your appreciation! Glad to know that this is useful for you. Thanks!
excellent. I have seen so many videos to learn something but did not get exactly what I want. You are the person who has given full code for download.
Tx for this very detailed and informative video. In short I'm wanting to get my monthly expense budget and income which I recorded on excel using a few sheets with 1st a data input sheet and 2nd a combined sheet using vlookup's and if_commands to compile a one-pager and 3rd a sheet with lookup's to use as as unique dropdowns in my data input sheet and 4th a pivot from my data input sheet to calculate etc. My issue here is that doing it this way it is very manual and with time a lot of data so IN ALL I tried this automated data entry form as per your tutorial without any coding experience and to my surprise my first input page worked 100%, thank you. Still a long way to get all functions I need but I have subscribed and will do all your tutorials and sure I will find answers for all my requirements.
Okay, first of all, excellent and thorough video/explanation. Now something personal. I am an American with an Indian spritual teacher who is Bengali (what is now Bengladesh), and as part of his dialog, he would always inject a little "...right" as he spoke. He was very dear to me. He passed away in 2007. I am sure you realize that you do this little vocal habit also. I am guessing you are Bengali, but regardless, just listening has given me so much joy! Thank you.
Amazing tutorial, I learn more in your first 10 minutes that I learned in the last 3 months, thank you ,
I recently discovered your tutorials on UA-cam and I am truly impressed by the simplicity and accuracy of all of your videos. The presenter is very knowledgeable, humble and has an eye to catch and debug errors. Your videos have helped me greatly!
I was hoping that you could help me with a very small question, and will try to explain the problem statement as accurately as possible..
In your user form, you are taking input from the record and storing in the database in each row. I have to create a database where there are default 4-6 rows for each entry with a YES/NO.
Example of how the input form would look like (with radio buttons for Y/N in Capability section) -
---------------------------------------------------------
Widget Supplier Name : ABC (freeform)
--------
Capability 1 | Capability 2 | Capability 3
Widget 1 : Y | N | Y
Widget 2 : Y | Y | Y
Widget 3 : Y | N | N
Widget 4 : Y | N | Y
--------------------------------------------------------
Expected result in Database should look like this -
Widget Supplier Name | Widget Name | Capability 1 | Capability 2 | Capability 3 |
ABC | Widget 1 | Y | N | Y |
ABC | Widget 2 | Y | Y | Y |
ABC | Widget 3 | Y | N | N |
ABC | Widget 4 | Y | N | Y |
Can you please help me with this? How should the code be modified?
Very clear and concise, step-by-step. Many thanks.
I have to share, my complete appreciation for this. I have never EVER done this type of thing before, and now I have a working form!! SUPER EXCITED!! THANK YOU!!!
WOWOW! This course was presented so well! BRILLIANT! Even someone Iike me at the amateur level can follow this lesson. Most importantly, after studying all parts in the links below, the results are a sophisticated design which includes macros VBA. It is IMMEDIATELY APPLICABLE FOR PRACTICABLE USE.
Thanks for your appreciation!
Wow! Thank you so very much! Your tutorial is so easy to follow. I was able to create my first VBA Form ever! I was able to also debug all the errors and get the form working! This is my first attempt at writing a code. Thanks very much!
Hi Data Lab's
Am receiving an error "could not set the RowSource property. Invalid property value." When I click Debug it tells me error is encountered under Sub Show_Form. How can I correctly that?
Your help with be greatly appreciated.
@@solangegorogo5962 make sure your tab is called also Database. It worked for me
Fantastic training tutorial !!!
Very simple and easy to follow along, clear instructions! The video setup, music, etc is also well made!
I have now subscribed and I look forward to see other instructional videos.
Thank you and God bless you and your family!
Thanks for your appreciation!
@@thedatalabs sir I have face a small problem that when I have fill all details and click the submit button then all fields are empty but which are create database list box are not show data
I feel one error in my software that when I update the tabIndex number are 10 then show error
It is also show -1
What's this solution
Thanks so much for this - very easy to follow and I have been able to customize it for my own application. I am having one issue, and that is that the database display on the form is only showing the first record entered. I can't find anything that is different from your demonstration. Do you have any idea what I might have got wrong?
Thanks
Thanks for your feedback! Seems there is an issue in the code where you are identifying the last row. Please check and fix that.
@@thedatalabs Spot on! I found it and corrected it - all working now. Thanks so much
Thank you very much for this video. I followed your steps carefully. I'm so happy I did it! I used it to encode the items we are getting from our cleaning supplies at home to keep track. very useful.
Perfect video I learnt a lot in 35 minutes. And I loved that background music perfectly tuned without distracting you!
Really well explained, thank you for your time and effort.
I hope you could do inventory management system using VBA. Sales, Purchase, Inventory using FIFO, Profit, etc. Thank you.
This dude literally knows everything.
What a lovely video. The form works as expected, and I was even able to make some alterations here and there without compromising its integrity. I appreciate this. Thank you.
Thanks for your feedback!
Do any of your videos provide coded examples of combo box objects with pull down list values derived directly from a worksheet table? It would greatly reduce the need for VBA skill level support if I didn't have to update VBA code every time a new LOV entry was required by a user. Ideally, as LOV entries are entered into a worksheet table, the form's combo box drop down LOV's should change in synch with the worksheet table. Is this possible? Do you have working examples of this code to share?
I need this too
Hi this is brilliant! However when i click the launch form at the beginning it stops working and frmForm.Show highlighted with yellow. How to solve this one? Thanks
having the same problem
yes same did u solve it?
same problem too, did you solve it? @TheDataLabs please help on this
sorted iRow = [Counta(Database!A:A)] + 1 close bracket after A:A was missing. Now my form will not save aaargh
@@natashammarara7268 Can you please elaborate on that? I have changed it to "iRow = [Counta(Database!A:A)] + 1" but it still wont work?!
Thank you for this info. Sir, could you make a video about checkboxes? Since it is very commonly used in forms.
This is awesome. I have just discovered this tutorial on UA-cam. I am happy I did.
Please do you already have tutorial to edit or delete record? I will appreciate if you can provide it. Well done.
Great work
Thanks for your feedback! You can watch the rest of the 4 parts out of 5. Links are available in the description box and pinned comment. Thanks!
Hello ! Many thanks for the video ! Is there a way to modify the display of the Database into the form to display the last entry first ? Many thnaks
Greetings from Mexico, all your videos are really amazing. Thank you for sharing your knowledge in such a simple and friendly way.
Thanks for kind words and appreciation!
Hi, I am using now the same program you made in your tutorial... and I am thankful to have this kind of vba program through your initiative. It is very nice and I learned many things in your tutorial from Part 1 to Part 5. Now. I would like to ask you a favor if you could add vba codes for having three (3) option buttons to add in the "Gender" portion,
like adding one more option button for undecided. Thank you.
Were you able to get an update on this for 3 options buttons?
You never fail to amaze me.
Hi, is it okay to email you ? I Need to ask you something, thank you
I finally can create a form in Excel!
Thank you! Such a thorough tutorial even someone who has little computer skill can follow.
I was able to come up with my very first automated data entry form by following this video! Thank you so much... Very clear to follow through
In writing the codes, kindly explain first the logic and sequence of your approach and from there you breakdown your sequence then you translate to writing codes that will make you more a good teacher.
Thanks for your feedback!
I am having an issue getting my form to display, when I try and open the form I get an error message number13 when I click Debug it highlights "frmForm.Show". Do you know how I am able to fix this, please?
This subprocedure is the procedure that should launch the form.
I hope your able to help me, I have been trying for two hours to work out what's happening.
Thank you for providing such an informative video.
I am getting the same error
Did you solve this error sir? How?
i have the same error too
I am facing the same issue. Pls help @theDataLabs
Same error here
Thank you very for the tutorial. But when i wanted to run i had this message "Run time error '13' , Type Mismatch". And also FrmForm.Show was in yellow colour .Please help me.
Thank you
Replace line with iRow = [Counta(Database!A:A)] + 1
Jacob, replace it with what?
Insert close bracket after A:A
thanks this helped
@@JacobWinton26 where to insert this. Im having same error
Really Loved your Video. I have no background of Computer Programming, yet have interest in Excel, and I'm re-watching your Video, this time I guess I've learnt something New.
Thanks a Lot sir for creating such a nice informative videos. Really Hats off to you Sir, how you explained things in this Video have become really easy to learn.... Once again, Thanks a lot Sir....
I'm working on my own utility for Stock and Invoice, I would like to share my work, once it is completed....
Thanks for your appreciation!
Dhanyche prakar vintal setp by step fromet kase karave
@@suhasubalekar1214 I couldn't understand your comment. You can use Hindi also. Mujhe Hindi bhi aati hai.
@@ayushjoshi1685 मला धान्य साठी h2 तयार कारण्यासाठी step by step userform म्हणजे धाण्याचा प्रकार प्राधान्य तांदूळ 10.75विंटल *230दर =2467.90किती वजा होऊन 10=2457.90 जादा व कमी असा fromet बाबत व्हिडीओ दयावा
Thank you for patiently showing the step-by-step vba coding. I was always afraid to use coding as I did not understand it at all.
Well done
I wonder...can multiple user using that form in the same time??
@AngusAranda Google sheet doesn't support VBA. We have a separate tutorial on Google sheets. Please watch that. Thanks!
Whenever i set the lstDatabase Tab index to 10, it automatically get reset to 0 ! Why is this happening ?
Same thing here! Found any fix for this in the mean time?
@@pascal.visser No mate
@@Shashikant-kq1el Too bad. But I saw in the movie exactly at 15:30 that he fills in '10' as value behind 'TabIndex' but that it immediately changes back to '0' as soon as he clicks out of the screen. You have to watch very close because it all happens very fast. So I think that it isn't a problem because the form works at the end!
Thank you for replying anyways! :D Have a nice day!
Thanks from pakistan.
I copy past you work on excel 2019.
Result on second form is not same. It shows only first line or first recording. Question is, how can i fix it?
Most welcome brother! Please download the Excel file from the same link. It will help you in understanding the code and issue. Let us know if you face any issues. Thanks!
you can replace the following code in Submit ()
iRow = [Counta(datasheet!A:A)] + 1
into
iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row 'Find the last non-blank cell in column A
@@georgelaghmjian4367 hello im getting an error with ws its telling me "Variable not defined" im new to this is there some chance you could help please
@@stevedelsy3998 after sub write
Dim ws as worksheets
Set ws = sheets("datasheet")
Thank you for your helpful and effective tutorial with this automated Data Entry Form in Excel!
Your video is helping me take my Excel reports to the next level! Thank you so much! I'll be checking out your other videos as well.
Someone told me that it's the best time to buy because there will be a huge pump
Someone told me that it's the best time to buy because there will be a huge pump soon little purchases is so surprising
I saw all this coming I had to switch to Crypto trading and I'm really enjoying the fact I made the right choice because of my weekly earnings
I make good income too from bitcoin trading and its been my most reliable source of income at the moment. With profits I've made so far I don't think i can get broke or lack anything.
How do you do it please
Because I've tried severally but seems not working
Hello. Unfortunatelly the "Submitted on" does not work for me. I have "#value" in that cell. Not sure what I inserted incorrectly.
EDIT: Got it. My mistake.
I really want to see the 555 faces who disliked the tutorial, are they from another planet??
.. Btw superb work brother 🥰😊🥰
Perhaps Americans like myself who find Hindi English extremely difficult to understand. They speak too fast and words blend into each other. Sometimes the words sound like a foreign language. This is why I will click out because it is not fun to learn like this.
@@sandrab2422 imagine being non-english and non-hindi person. I have to understand and then translate this on my head to my native language.
@@andrusaren8348 definitely the wrong channel for you me and countless others who can’t understand this fast spoken incomprehensible English. He keeps getting clicks and making money off content that isn’t suitable for all. He should tag his content “Hindi English”
Thanks bro the video is very helpful. I subbed and liked
type mismatch in the " sub show form" code. Edit: i make it work by editing the source code that this genius man provide it to us for free. I can't thank you enough Sir. keep the good work.
Thank you soooo much!!! This was easy to follow and understand. It's like I learnt VBA in two days. Brilliant!
Super helpful....had to play around with the cmb box to get it work.....this example when reopened doesn't show the selections unless I pressed reset. I had to put them above the "show form" line in the last sub prog
Very well explained. You are an amazing teacher. Thank you very much my brother.
Excelente taller de ingreso automático de datos, felicitaciones
Thanks a lot I want to learn basic things of Form, you teach me thru this video.... many many thanks
Wow..you are a very patient teacher/tutor. Your explanations are so easy to understand. I'm learning quiet a lot from your presentations although I am starting to use Excel. Its so exciting and I love learning from you. Thanks so much all the way here from Papua New Guinea.
Wow! Thank you so much. Never imagined I could do it with the help of your tutorial.
Awsome video, thank you very much.
I just have 1 question, I need my database to be shown backwards, the last service has to be shown on top, how can I program this.
Thanks for your feedback! To do that you need to change the logic in identifying the next blank row. Please keep the iRow as 2 and insert a blank row after the Column Headers and then update the data. In this way, your previous data will be shifted below.
@@thedatalabs thanks alot :D
Thank you very much. I developed an excel sheet with the help of your tutorial for my work.
I love you, my dear Indian friend. Your direct and easy explanation has made my life better. I was able to complete a homework related to this topic. I hope you have an amazing day!
You are most welcome
This is amazing. Thank you so much. I have spent so much time trying to do this very thing.
Excellent. Well explained and immediately applicable. Thanks Dilip.
Thanks for your kind words!
Thank you very much for this series! Please help me with this message after 15:27 in my PC (The macros in this project are disable. Please refer to the online help or documentation of the host application to determine how to enable macros.)
Thank you for this tutorial, it was very easy to follow and helpful for me as a beginner
Well done bro i have created my own software with your help for the first time
Thankyou for this video
Actually, this video is so clear, thank u very much .and this is GOAT " Grate Of All Time"
Good morning sir I have seen today 3 videos on the same matter. Though those are in different format, I feel that your work is wonderful, as it is the form what I want the type. Regarding, adding some more buttons/ features like Edit, Deleat, I request to add few more buttons like i) Search for name / Emp. Number, 2) Do you find what do you want Y/N, 3) Do you want enter some more details, 4) Entered by. Thanking you sir- Y/F, Velmula Krishna Rao.
Thank you very much for sharing!
Could you please add a scroll bar to the database? If we have many rows, it's tough to reach the last row.
Thanks for your feedback! If I am not wrong then Scrollbars will be automatically added to the VBA listbox if the space is not enough to show all the columns.
Let me know if you are unable to see when column length gets exceeded.
@@thedatalabs well noted. Could you please show me how to skip a field (textbox or date picker) if a previous one met a condition? For example if the order was not delivered, skip the date of receipt.
Thank you!
I have start learning VBA Macro thru online,this video explanation ,video quality excellent ,Pls add new vba macro coding video ,
Thank you very much.
You teaching in detail everything.
I know VB 6 very well but I didn't know the VBA procedure. Now I can work with this thanks a lot
This is useful. Thanks. Can I add a button to "print" and "print" will go through the database and print 5 google documents for each record, customizing the first line of each document with the first and last name that's in the database ? Is it possible to work google sheets and docs together like that ? Thanks
Yes, it's doable. Thanks!
Thank you for the amazing tutorials. Can I ask u why if I store data on spreadsheet everything is fine, but if I try to create a table apparently the form doesn’t connect to the sheet and I have a run time error?
Thanks for your feedback! Please watch this tutorial to connect with table.
ua-cam.com/video/QXK7MA5sa44/v-deo.html
Completely new to this, so i'm creating as i watch, im on min 23:47 when he hits debug, however when i do that, an error message pops up that says Compile error: Method or data member not found and the highlighted section lists ".lstDatabase" im sure im missing something, because I had an error message show up earlier and i was able to correct it because it doesn't appear anymore. any help would be appreciated.
i wrote list wrong ...
THX.. its 1000% work .. very clear explanation
Proper coverage of topic which was point to point . Only would request to also include brief explanations of what you are using throughout,, eg., How does "With" works, What is "With" used in vba code, etc. to get idea instantly about them
Thank you. Do you have tutorial for using calendar to search?
Thankyou bro, ur way of explaining is clean and clear. I learnt lots of things in this.🙂.
Best tutorial I have ever seen, so direct and hands-on approach anyone can be familiar with VBA form. Thanks for the generous sharing!
How can VBA form be used by multi users and data updated into excel form? Or is it limited to one user where the VBA is installed?
thank u very much for your effort... my project done becoz of yyour video
Good to hear that. Thanks! Please subscribe hour UA-cam channel.
Thanks for this amazing video, how do i handle a situation where I have a lot of input boxes about 50 of them? What is your suggestion on how to arrange the text boxes in a clean way
Thank you so much for the great Video! I have a question: what if the department entry has one text option: for example: HR, sales, marketing, other: . How do we code for that? Thank u
Superb explanation sir... Tq for ur useful source code and user friendly form... Very nice
Hi. Thanks for this tutorial. It does helps me a lot. Would you mind to show, how the database can appeared in reverse order, meantd the latest to appeared at the top of the database?
Thanks for your feedback! You can take help from this tutorial.
ua-cam.com/video/QXK7MA5sa44/v-deo.html
@@thedatalabs Hi. I just tried this link using the layout from the video above (current video) and can't get it to work. Can you please layout the code here so we can insert it?
Thanks and GREAT videos!! Very Useful!
This is great, I learned a lot. More power.
Sir, Hands off this is a very very good effort of yours
Done my first tutorial!!! great mi pana!!!!
I appreciate your effort. salute from East Africa
Best tutorial I’ve ever seen...no 🧢
Hi, Thank you for the video. I am looking to create a Userform in Excel 2016 on a Mac but unfortunately the form feature is not present in Excel 2016 on Mac. Is there any other alternative to this?
Years ago i made data entry user form in Word. My job was to fill some standard contracts with data. Different peoples names, two copies etc etc. After that they fired me :D
I automated things. Covernment job you know. I filled contracts faster than anybody at that time and without errors. With Vbscript help of course.
Thank you so much. It is very useful one.
Unfortunately, I am not getting the second line on the dash board. Can you help me on this?
Hi, may ask where can I find user form in Excel 2022? It only has Module included. Thank you so much!
Hello, thank you for the viewo, its super informative. Can you help in making the form multi user, i.e., can multiple pple input data in the same form?
Very well explained, thank you so much.....I would like to know how can i find the music you play on the background I notice that it improve my attention span.
Thanks for your appreciation! You can find the music in Camtasia music library.
Hi your video is amazing! very helpful , I'd like to know if you have video for deleting , updating or modifying (search the data first then update) , also if possible to search certain data via text. I have 100 product and from time to time we update it details like price and we save it or duplicate it but with different product code.. thank you very much
Thanks for your appreciation! This series has total 5 parts. It covers all the functionalities e.g. edit, searc, delete, validate, print etc. I would recommend you to watch all the parts and let us know if you have any question. Thanks!
Great Tutorial! Thanks Dilip! I need to create a simple entry form for 6 fields and I am trying to control the progess of filling in a way that the user can not move to the following field until the value is correct. I am using the event private sub fieldname_exit(ByVal CancelAs MsForms.returnbolean) to validate the input value... however in can not retain the cursor in the field when the value is wrong as it jumps to the following field even when I include in the code the sentence formname.fieldname.focus pointing to the field with the wrong value. Could you please give me some hints to do it? Many thanks and congratulations for your great tutorials.
Thanks for your feedback! Please share the file. You can find our email id in the description box. Will check and get back to you.
Wooow This Tutorial Is super useful and was presented in a perfect way. Thanks TheDataLabs
Thanks for your feedback!
Hi and thanx for the video. Actually I need next combo list to be dependent to the previous. How is it possible during the coding procedure?
Perfect tutorial. Nothing better than learning the principles in simple form. Thanks a lot. Great work.
Love the way of simplicity yet clear information on excel vba with basic example.