Thank you very much Sir for your effort. It was very helpful to me and I'm happy people are sharing their knowledge with each other no wonder 24 hr is not enough anymore! I guess we all want to know and learn more :)
Great video. However I have tried to make a form with different headings for a different application. I am having trouble with the save function and and error is showing that it’s can’t find end(x1Up) in project or library. What would be the cause of this? Thank you
Amazing video if you're already familiar with VBA but I wouldn't recommend it to beginners since it lacks a commentary on what those specific line of codes do.
Great video. It evens works. Wondering if you have a video the you can pull information from the Date Sheet to Edit or just to Retrieve. That would be most helpful. Keep up the GREAT work. David
@@thedatalabs Hi There, Thanks for the video. Could you pls show the video with all function as per this stuff ? I like this way rather than make user form. How can move the mouse from this tab to other tab by click enter? Many thanks! 🌹🌹
Very good video, I need to make a similar form but for simple calculations instead of data entry, I only need the reset and calculate buttons, the formula is =((D5+D7)-(D4))/2/TAN((D6*PI()/180)) Thanks
Thank you for your effort and sharing with us. I have suggestions regarding the tutorial: You're doing alone most often without describing what you do, the steps to follow, and other important details users can experience challenging. It also seems that you run quite fast so that any interested can hardly follow you. While you are presenting a topic that is interesting, the way you presented is not attractive and does not help much.
Thanks for your appreciation and feedback! It matters a lot. Would request you to watch our latest videos on creating Form. We have covered the topic in detail. ruclips.net/video/P53T6oxgUVA/видео.html Thanks!
Dear Dilip, Thank you for your very impressive videos on developing and creating databases using excel. I have been watching your video's for a very long period of time where I tried to do a lot of practices but I couldn't make it. due to different heading we are using with you. I want you to practically share a video on you tube with some heading like this LGA, Ward, Name, Settlement, Phone Number, Gender, Designation, Account Number, Bank Name. Because after I watched your videos I tried to do above and I find it difficult to do it. and it seems there is other things that is not in the videos that was missed. I would be very grateful, If your request is considered. Thank you Lawan Kakaji From Nigeria
Good video though... but the auditory type of learnings along with visual will make the viewers learn faster. May be one by one line of code in the VBA should have been better... Naturally, any student would like to learn how to do it than seeing the outcome of the exercise... In your video the results have come and you are an expert, but the trainee need to understand... the efforts are appreciated but understanding by the viewer is a bit difficult... regards
Great video Sir :) but still I find it difficult to understand since I dont have any knowledge about VBA ... Can you help me ? I wanted to create a DATABASE a TRACKING DOCUMENT could it be possible with Data Entry ?
@@thedatalabs sir while filling the data entry for tab key doesn't work, we have to use mouse to jump to next option...😕 Crap! Please help me sir what should i do?
was this video every made explaining vba? Very interested! btw incredible video for simple tasks. I am curious about this given that this seems to be a alternative to access. @@thedatalabs
Thanks for watching and feedback! I will upload a new video on creating an automated form covering step by step. Please comment your suggestion or requirements so that I can cover those points as well. Thanks!
Great Tutoral Thank you Have a tutorial video about one table adding new records? (for example one person buying products from a store and excel can list buying products and prices ) I want learn this
The Kashrelli principle states, "The inference level of a meta-group is indirectly proportional to the root of its scalar phase multiplied by Grykshtein's Constant"
While editing the save button, how did you get the huge number in the ranger function: iRow = Sheets("Data").Range("A#######").End(xlUp).Row + 1 Excel tells me this is the only line in my code that's messing up...
I'm just a new comer. I don't know how to coding like you did in this Video. However, when I've got free time, I tried to do it on and on. I have a question. Can you write "Visual Basic" for download? Because I have no idea about "Coding" --I'm never study like this before. Thanks a million--for your very useful video. AAA+......:)
Thanks for your appreciation! Please explain your requirements. I will try to create video on that topic as well. You can find eMail I'd in description box. Please send your requirements. Thanks!
slow down with an explanation! you act like we all know what is going on - I wouldn't be looking for a tutorial if I knew all the buttons and what they are for and how they operate
Excellent. This form almost worked first time. Then I realised I had CELL reset instead of CALL reset. Once I'd corrected that it worked perfectly. Is there any way to replace a record though? Say the 330th record of some 2000 needs amending.
HI Dillip, What I mean is.....say you have hundreds of entries, how do you create a search button on the user form to narrow down the entries so that you can edit or delete ( a filter )
Thank you very much, Sir. It is a great way to speed up database management with much effectively. Love you a lot for uploading your such video on RUclips.
Hi Admin, I followed the instruction you mentioned in editing the properties of the Text Box. Here is the step I did: 1. Developer>Insert> TextBox (under ActiveX Control) 2. Draw Text Box 3. Select Text Box>Click Properties in the Developer tab 4. Change Name to txtName However, it is still not allowing me to add text in the box, unless I do this: right click>TextBox Object>Edit Can you please advise where I went wrong? Thanks in advance!
Thanks for watching! Sheet based form has no option to set Tab order. You need userform to create the form and set Tab order. Please watch this video. ruclips.net/video/P53T6oxgUVA/видео.html
Thanks for the coding through such a easiest way. My rest button is working (feeling wow, as i am not familiar to computer) But save button is not shown any interest 😒 neither warning nor saving Can you tell what mistake i may be done
Hi Mr. Can you give some details please how to build the commands and orders of VBA page (what every single line mean?) in order to understand what you did in the session. Thank you for responding
Hello sir. your way of teaching is very good. but i didn't understand the coding what are you doing in visual basic Vba code .... a work of coding i can't understand soo please make a one video on vba coding in easy way of procedure to how we can do easily in preparing of data entry form....... thanks i like your video...
Thanks for your appreciation! Accelerator key is the underline key available on command button. It will work like shortcut key. You need to press ALT + Accelerator Key to run the code assigned on that particular button.
That is really nice tutorial. Thanks! I have one question, please answer. If this form is used by multiple users and they are saving data at the same time. This is overwriting the data of the other user with the last user. Please suggest how to avoid data conflict. Regards, Prashant
good lesson and very interest for me but it was very fast and quickly if you want to see your lesson other people, please give lesson slowly. Thank you so much,
Thanks for your feedback! It seems you have not declared the variable or there is mismatch between the name you have declared using Dim keyword and the variable you are using in rest of the codes. Thanks!
Thanks for sharing your videos. Can we have selective cells in different sheets from one workbook to enter the data. For example; three different cells from sheet1 while other cells in sheet 2.
Is it possible to have the data going to different sheets depending on what was entered into a certain box? So for example each city would have its own sheet, and when that city was entered the data would go to that sheet? Thank you :)
Dear sir I am a huge fan of yours...I would like to know one thing that if combobox is dynamic...it change according to user requirements then how can we validate...as you shown in your videos 10th 12 th and so on....what if combobox is dynamic then what can we do
Thanks for your appreciation! I will upload a tutorial on creating Data Entry Application in Excel and Access. I will make the drop-down dynamic. Please stay tuned. Thanks!
Thanks for watching! Will keep uploading more videos on form, dashboard, Excel, Power BI and some most frequently used automated tool. Please post your suggestion, if any. Thanks!
Hi admin, I am really interested in this lesson but i don't know how to command what I want.
Please watch the complete tutorial.
ruclips.net/video/I-Ze6bX7ous/видео.html
Having trouble with this part (x1Up). It gives an error message ( Variable not defined.) Please, advise! Thanks
@@keepcool6720 It has to be written as: "(xlUp)". the second character has to be a 'l' not a '1'
@@nikinikcc Thank You
@@nikinikcc thanks sir.
I've never been this lost, will have to put you on slow motion when I get started on it. Otherwise you are an expert on it!
सर आप का बहुत बहुत धन्यावाद इतनी अच्छी विडियो बनाने के लिए। 🙏🙏
Thank you very much Sir for your effort. It was very helpful to me and I'm happy people are sharing their knowledge with each other no wonder 24 hr is not enough anymore! I guess we all want to know and learn more :)
...and that's how you get an MS Access database from Excel
Good job!
You saved me hours of time!! You're the bestest (not a word but it fits here lol)!!!
Very nic aapke experiment ne mujhe aisa jhatka diya ki aapka chanal subscribe hi karwa diya,thanks isi tarh se aap aisi acchi vedios bnate rahiye
Thanks for your kind words and appreciation! 🙏
Thank you for make this available via download!
hello
you are the best man in the world!!!!!!!!!!!! you saved my exams!
Thank you, I haven't done this in years and needed to relearn.
Thanks a lot. I am from Peru and you helped me a lot.
This is perfect! I hate long dragging videos with a lot of talking.
Real tutorial. Thanks
This is so complex. it can be make only by using macro. Thanks
outstanding tutorial, thank you for posting
Great video. However I have tried to make a form with different headings for a different application. I am having trouble with the save function and and error is showing that it’s can’t find end(x1Up) in project or library. What would be the cause of this? Thank you
VERY USEFUL VIDEO SIR YOU ARE TEACH SUPER SO MORE UPDATE
If you can explain code line by line, how it function and perform task it would be more helpful. But Very good form.
Thanks for watching! Will provide full explanation on website. Will share the updated link. Will also post a video on upgraded form.
Can we get this Excel templete????
Please download the template from the link provided in description box. Thanks!
what a good job! I reel need it
Amazing video if you're already familiar with VBA but I wouldn't recommend it to beginners since it lacks a commentary on what those specific line of codes do.
Thanks for your appreciation and feedback! Will upload a video explaining each and every step. Thanks!
@@thedatalabs when?
This is a very good.
I don't knew macro also but I learn it now!
Great video. It evens works. Wondering if you have a video the you can pull information from the Date Sheet to Edit or just to Retrieve. That would be most helpful. Keep up the GREAT work. David
Thanks for your appreciation! Will upload a video to edit and delete the updated data. Thanks!
@@thedatalabs Sounds good, will look forward to the video. i have subscribed. David
Thanks!
Thank you bro,,,,keep it up in english
That’s 👍
Please show, search, delete & updating records in the same excel
Thanks for your appreciation and suggestions! I will upload a video covering all these functionalities.
@@thedatalabs Hi There, Thanks for the video. Could you pls show the video with all function as per this stuff ? I like this way rather than make user form.
How can move the mouse from this tab to other tab by click enter?
Many thanks! 🌹🌹
Gr8 explain step by step really 😊
Simply Brilliant..
Very good video, I need to make a similar form but for simple calculations instead of data entry, I only need the reset and calculate buttons, the formula is =((D5+D7)-(D4))/2/TAN((D6*PI()/180))
Thanks
You can use blank value on Reset and Formula on calculate button. Just assign the blank or relevant formula on calculate button as per requirement.
Genius! Im getting hooked on your mind-boggling video tutorials 🤯🤯🤯
Thank you for your effort and sharing with us. I have suggestions regarding the tutorial: You're doing alone most often without describing what you do, the steps to follow, and other important details users can experience challenging. It also seems that you run quite fast so that any interested can hardly follow you. While you are presenting a topic that is interesting, the way you presented is not attractive and does not help much.
Thanks for your appreciation and feedback! It matters a lot. Would request you to watch our latest videos on creating Form. We have covered the topic in detail.
ruclips.net/video/P53T6oxgUVA/видео.html
Thanks!
@@thedatalabs Thank you for the positive and helpful response.
Most welcome.
They need to slow down a bit, tutorials are normally too fast.
Dear Dilip, Thank you for your very impressive videos on developing and creating databases using excel. I have been watching your video's for a very long period of time where I tried to do a lot of practices but I couldn't make it. due to different heading we are using with you.
I want you to practically share a video on you tube with some heading like this
LGA, Ward, Name, Settlement, Phone Number, Gender, Designation, Account Number, Bank Name.
Because after I watched your videos I tried to do above and I find it difficult to do it. and it seems there is other things that is not in the videos that was missed.
I would be very grateful, If your request is considered.
Thank you
Lawan Kakaji
From Nigeria
Good video though... but the auditory type of learnings along with visual will make the viewers learn faster. May be one by one line of code in the VBA should have been better... Naturally, any student would like to learn how to do it than seeing the outcome of the exercise... In your video the results have come and you are an expert, but the trainee need to understand... the efforts are appreciated but understanding by the viewer is a bit difficult... regards
Thanks for your feedback and appreciation! Will upload a video covering step by step. Thanks!
Excellent! If you explain the code also in your next VDO, it will very helpful for Excel VBA beginner.
Thanks for your appreciation! Will definitely upload a video explaining every step.
coolag74 your right. . Its a bit complicated with the codes.
Thank you for sharing the video, but your going fast without description.
Thanks for video brother 👍
Great video Sir :) but still I find it difficult to understand since I dont have any knowledge about VBA ... Can you help me ? I wanted to create a DATABASE a TRACKING DOCUMENT could it be possible with Data Entry ?
Thanks for appreciation! I will upload another video with full explanation. Please keep watching.
Please send Ur requirements on thedatalabs@gmail.com
@@thedatalabs sir while filling the data entry for tab key doesn't work, we have to use mouse to jump to next option...😕
Crap! Please help me sir what should i do?
was this video every made explaining vba? Very interested! btw incredible video for simple tasks. I am curious about this given that this seems to be a alternative to access. @@thedatalabs
Ahad Moham I am having the same issue. Did you get an answer?
@@thanatosirons noh mate, it sucks when i recall my effort in doing that😠
got a sub nd like, thnq so much for the code, it is working fine
You give your time to make a Video but u dint want to describe why and how do u select the commands and Formulas in Excel.
Thanks for watching and feedback! I will upload a new video on creating an automated form covering step by step. Please comment your suggestion or requirements so that I can cover those points as well. Thanks!
Thank you this is help full .
Bro u have good knowledge but u can't share properly plz do slowly so other lern easily
Thanks for your feedback! Will definitely do this in upcoming videos.
Just slow the video using the setting in the bottom right of the video screen.
Correct! Knowledge is one thing, but the ability to share that knowledge is another thing.
Great Tutoral Thank you
Have a tutorial video about one table adding new records? (for example one person buying products from a store and excel can list buying products and prices ) I want learn this
You are going way too fast and not explaining what you are doing. I can't follow you.
If we want to Edit any entry how can we do please explain and do not repeat duplicate entries.
The Kashrelli principle states, "The inference level of a meta-group is indirectly proportional to the root of its scalar phase multiplied by Grykshtein's Constant"
great video although you should explain what are those vba codings for, because not everyone is programmer here.. thank you
Thanks for your feedback and appreciation!
Interesting video but hard to follow. This is only for audiences who already have the advance knowledge.
Thanks for your appreciation and feedback! Please watch this video to create form step by step.
ruclips.net/video/I-Ze6bX7ous/видео.html
Right, man!
Excellent tutorial! Is there a way to insert a photo image for individual entries, and have it appear on the UI form?
Hello,
super video but why your so fast in doing cant to make slow
Thanks for your feedback! I will upload a video on creating an advanced form covering maximum controls with full explanation.
Great work some parts were difficult to understand but i fix the problems and it works perfect thanks new sub for you :)
Visual basic is not show according to your guidelines/ video. Please update me
Will upload a video explaining it. Thanks!
Thank u for easy format study
While editing the save button, how did you get the huge number in the ranger function:
iRow = Sheets("Data").Range("A#######").End(xlUp).Row + 1
Excel tells me this is the only line in my code that's messing up...
Please replace "A#######" with "A65000”
The number denotes the last row number in Excel sheet.
It will work. Thanks!
@@thedatalabs have replaced as you said but I am still getting the error saying
run time error:13
type mismatch
Please help me...
I'm just a new comer. I don't know how to coding like you did in this Video. However, when I've got free time, I tried to do it on and on. I have a question. Can you write "Visual Basic" for download? Because I have no idea about "Coding" --I'm never study like this before. Thanks a million--for your very useful video. AAA+......:)
Thanks for your appreciation! Please explain your requirements. I will try to create video on that topic as well. You can find eMail I'd in description box. Please send your requirements. Thanks!
You're too fast...need to slow a bit.
Can't grasp the steps as you've done it like someone's chasing you.
Naaw
Great video....p.s. guys use the code written here....the one on the website has bugs.... admin kindly look into it
slow down with an explanation! you act like we all know what is going on - I wouldn't be looking for a tutorial if I knew all the buttons and what they are for and how they operate
Thanks for your feedback!
I have uploaded a video considering feedback from viewers. Please watch this.
ruclips.net/video/P53T6oxgUVA/видео.html
Can use table and forms for that, good stuff .
Excellent! thanks so much sir :)
Is it possible after adding data then directly send the details to an email pls let me know
Thanks for watching! Yes, It's possible.
Yeah it is required for myself too..shall I share my mail I'd here..or ...
It is very useful. Super
Thanks for your appreciation!
Thanks for your efforts
14:45
What does "iif" stands for?
IIF is just like IF function in worksheet.
@@thedatalabs mine iff is error, why?
Please send me the snapshot of code where you are getting error. Please copy and paste here.
Easy to do. Thanks
Good Job Sir...
Hi, your videos are good, can you share or include the code for Data Exists message while entering the employee name or save the database
so hard to understand for the beginners with your speed approach but its interesting
Please watch this video for step by step approach. Thanks!
ruclips.net/video/P53T6oxgUVA/видео.html
Awesome video
Thanks for your appreciation!
Excellent. This form almost worked first time. Then I realised I had CELL reset instead of CALL reset. Once I'd corrected that it worked perfectly.
Is there any way to replace a record though? Say the 330th record of some 2000 needs amending.
Thanks for your feedback! I didn't understand your requirements. Could you olease explain little but more so that I can suggest Thanks!
HI Dillip,
What I mean is.....say you have hundreds of entries, how do you create a search button on the user form to narrow down the entries so that you can edit or delete ( a filter )
सर अगर आप हिन्दी मे भी समझते। तो बहुत ही अच्छी तरह समझ मे आता सर।
Thank you very much, Sir. It is a great way to speed up database management with much effectively. Love you a lot for uploading your such video on RUclips.
this is amazing, does anyone knows if this is possible in google sheets?
Thanks for your feedback! Please watch this Google Sheets Tutorial.
ruclips.net/video/Q-Io0Y59nYA/видео.html
@@thedatalabs thanks a lot, I'll watch it right now, appreciate it
It works perfect. Thanks
Hi Admin,
I followed the instruction you mentioned in editing the properties of the Text Box. Here is the step I did:
1. Developer>Insert> TextBox (under ActiveX Control)
2. Draw Text Box
3. Select Text Box>Click Properties in the Developer tab
4. Change Name to txtName
However, it is still not allowing me to add text in the box, unless I do this: right click>TextBox Object>Edit
Can you please advise where I went wrong?
Thanks in advance!
I think you are still in designing mode. Please deselect the designing mode then use the text box or other controls. Thanks!
@@thedatalabs Oh yeah! Great. Thanks.
You are really very good knowledge
Thanks for your appreciation!
Thank you very much for your video please if i want to use only the tab key to move between texbox what is the solution
Thanks for watching! Sheet based form has no option to set Tab order. You need userform to create the form and set Tab order. Please watch this video.
ruclips.net/video/P53T6oxgUVA/видео.html
Very nice...
This video is very simple to learn and helpful as well.
I also made the excel file but getting wrong value entered in Data Sheet.
Thanks for your appreciation! Please share the code where you are getting error. Will fix it. Thanks!
@@thedatalabs Kindly provide email id so that i can share
very nice bro God Bless you
Thanks!
Important to learn
Thanks for the coding through such a easiest way.
My rest button is working (feeling wow, as i am not familiar to computer)
But save button is not shown any interest 😒 neither warning nor saving
Can you tell what mistake i may be done
Mantap bank support chanel
Hi Mr.
Can you give some details please how to build the commands and orders of VBA page (what every single line mean?) in order to understand what you did in the session. Thank you for responding
Hello sir. your way of teaching is very good. but i didn't understand the coding what are you doing in visual basic Vba code .... a work of coding i can't understand soo please make a one video on vba coding in easy way of procedure to how we can do easily in preparing of data entry form....... thanks i like your video...
Good and useful
Thanks for your appreciation!
Hi! great video! I really learned a lot.. how can I add search by name command on this? Thank you!
Thank you very much for this video.
@ 5:38 What is the Accelerator property for, and why set one command button as "s" and the other as "e"?
Thanks for your appreciation! Accelerator key is the underline key available on command button. It will work like shortcut key. You need to press ALT + Accelerator Key to run the code assigned on that particular button.
Very useful video,thanks . I want to know how to create delivery challan
Thanks for your feedback!
Please details to make finished goods market delivery challan
nice work by dilip
Thanks for your appreciation!
Supper
explanation and very helpful
Very helpful, thanks
Thanks for your feedback!
That is really nice tutorial. Thanks!
I have one question, please answer.
If this form is used by multiple users and they are saving data at the same time. This is overwriting the data of the other user with the last user. Please suggest how to avoid data conflict.
Regards,
Prashant
Thanks for your feedback! Please watch this tutorial for multiuser form.
ruclips.net/video/6LsUmstJOX8/видео.html
Csngsoowj
Thank you very much for this great video and for this valuable information.
Thanks for watching! Please subscribe, like and share.
I want to ask about auto shifting of cursor to next required box instead of selecting each box by mouse click to enter data.
good lesson and very interest for me but it was very fast and quickly if you want to see your lesson other people, please give lesson slowly.
Thank you so much,
Thanks for your appreciation and feedback! Please watch this video. It is step by step.
ruclips.net/video/I-Ze6bX7ous/видео.html
This is very good for me.Sir i have one error massage in qualification like "Variable not defined",please help to solve this
Thanks for your feedback! It seems you have not declared the variable or there is mismatch between the name you have declared using Dim keyword and the variable you are using in rest of the codes. Thanks!
pure skill
GOOD JOB THANK YOU TheDataLabs....
Thanks for sharing your videos.
Can we have selective cells in different sheets from one workbook to enter the data. For example; three different cells from sheet1 while other cells in sheet 2.
Yes, we can do it. You can perform all the conditional movements of data through VBA code. Thanks!
@@thedatalabs can you provide me the code how it'll be perfomed
@@thedatalabs I know its vba but my question was very clear, what are the vba codes for that function ?
Is it possible to have the data going to different sheets depending on what was entered into a certain box? So for example each city would have its own sheet, and when that city was entered the data would go to that sheet? Thank you :)
Thanks for watching! Yes, it's possible to transfer the data basis on city selection.
You can also use pivot table after having data entered
Dear sir I am a huge fan of yours...I would like to know one thing that if combobox is dynamic...it change according to user requirements then how can we validate...as you shown in your videos 10th 12 th and so on....what if combobox is dynamic then what can we do
Thanks for your appreciation! I will upload a tutorial on creating Data Entry Application in Excel and Access. I will make the drop-down dynamic. Please stay tuned. Thanks!
Nice vedio
Superb
Thank you so much for your video. I learnt a lot from it.
Thanks for your appreciation!
Thank you for your kind efforts... Please go on with more, i'll be intouch with you
Thanks for watching! Will keep uploading more videos on form, dashboard, Excel, Power BI and some most frequently used automated tool. Please post your suggestion, if any. Thanks!