How to make Macro enabled Form in Excel Sheet?
Вставка
- Опубліковано 27 сер 2024
- In this video we will learn how to create a macro enabled form in Excel Sheet to save data in another sheet in same workbook.
#MacroForm #DataEntryForm
New Tutorial on form with add, modify, delete and reset - Step by Step
• How to Create a Data E...
Please download the form and VBA code from the below link.
thedatalabs.or...
Please reach out to us on
info@thedatalabs.org
www.thedatalabs.org
Thanks for watching!
Please subscribe our UA-cam Channel.
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.
ua-cam.com/video/I-Ze6bX7ous/v-deo.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, I haven't done this in years and needed to relearn.
सर आप का बहुत बहुत धन्यावाद इतनी अच्छी विडियो बनाने के लिए। 🙏🙏
you are the best man in the world!!!!!!!!!!!! you saved my exams!
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 :)
Thank you for make this available via download!
hello
...and that's how you get an MS Access database from Excel
Good job!
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.
This is so complex. it can be make only by using macro. Thanks
Real tutorial. Thanks
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! 🙏
You saved me hours of time!! You're the bestest (not a word but it fits here lol)!!!
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!
VERY USEFUL VIDEO SIR YOU ARE TEACH SUPER SO MORE UPDATE
Thank you bro,,,,keep it up in english
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?
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! 🌹🌹
This is a very good.
I don't knew macro also but I learn it now!
Can use table and forms for that, good stuff .
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!
Genius! Im getting hooked on your mind-boggling video tutorials 🤯🤯🤯
सर अगर आप हिन्दी मे भी समझते। तो बहुत ही अच्छी तरह समझ मे आता सर।
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.
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
Simply Brilliant..
Thank you this is help full .
Thank you for sharing the video, but your going fast without description.
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!
outstanding tutorial, thank you for posting
Gr8 explain step by step really 😊
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 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.
ua-cam.com/video/P53T6oxgUVA/v-deo.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.
Thank u for easy format study
Good Job Sir...
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.
ua-cam.com/video/I-Ze6bX7ous/v-deo.html
Right, man!
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.
Thanks for video brother 👍
so hard to understand for the beginners with your speed approach but its interesting
Please watch this video for step by step approach. Thanks!
ua-cam.com/video/P53T6oxgUVA/v-deo.html
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"
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.
Important to learn
pure skill
Visual basic is not show according to your guidelines/ video. Please update me
Will upload a video explaining it. Thanks!
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😠
Great video....p.s. guys use the code written here....the one on the website has bugs.... admin kindly look into it
It works perfect. Thanks
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...
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.
ua-cam.com/video/P53T6oxgUVA/v-deo.html
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.
ua-cam.com/video/I-Ze6bX7ous/v-deo.html
what a good job! I reel need it
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
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 ...
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.
You are really very good knowledge
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.
Great work some parts were difficult to understand but i fix the problems and it works perfect thanks new sub for you :)
Nice vedio
nice work by dilip
Thanks for your appreciation!
It is very useful. Super
Thanks for your appreciation!
Nice video
very nice bro God Bless you
Thanks!
Superb
Good and useful
Thanks for your appreciation!
Awesome video
Thanks for your appreciation!
Easy to do. Thanks
Supper
explanation and very helpful
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 UA-cam.
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!
Brilliant
GOOD JOB THANK YOU TheDataLabs....
Excellent! thanks so much sir :)
got a sub nd like, thnq so much for the code, it is working fine
Very helpful, thanks
Thanks for your feedback!
I´m grateful there are so many "how-to´s" with reference to Excel-VBA here on UA-cam. However sometimes I wish there would be more explanation to some of the videos. What´s the use of it when I get a "snippet" of VBA-code that I don´t fully understand?
That for your feedback!
Thanks for your efforts
I appreciate your great works sir... I request u to go a little but slow so that we can follow u
Thanks for your appreciation and feedback!
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
i will learn
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
excellent
Thanks your appreciation!
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
Thanks for sharing , I like your lesson you provide us the coding
Thanks for watching and your appreciation!
Nice, It Works
Thank you so much for your video. I learnt a lot from it.
Thanks for your appreciation!
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
Thank you very much for this great video and for this valuable information.
Thanks for watching! Please subscribe, like and share.
Nice
superb
Thank you really appreciate your work
It's good video
Thanks for your appreciation!
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
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!
Thank You So Much Sir.
Hi sir Great video
Thanks for your appreciation!
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
Mantap bank support chanel
I love it. Thank you.
You are working soooo fast. The novice will not get anything learnt from your video.
Thanks for your feedback! Will upload a video explaining every steps.