Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)
VloĆŸit
- Äas pĆidĂĄn 4. 07. 2024
- Join 400,000+ professionals in our courses here đ link.xelplus.com/yt-d-all-cou...
Unlock the secrets of Excel VBA with our comprehensive guide on using the Visual Basic Editor (VBE)! This is the place macros from the macro recorder are recorded as well as the place you'll be writing any VBA code.
This video is your first step towards mastering Excel VBA, making it a must-watch for both beginners and seasoned Excel users looking to enhance their productivity and workflow efficiency.
Get access to the full Excel VBA Course here đ www.xelplus.com/course/excel-...
Learn how to navigate and utilize the VBE, from creating auto-updating charts with Excel macros to customizing your workbook with advanced VBA code. Discover the favorite methods to access the VBE, essential components like the Project View, and tips on activating useful tools like the Properties and Immediate Windows.
00:00 How to Use the Visual Basic Editor in Excel
00:26 Introduction to the Visual Basic Editor
09:36 Visual Basics and Color Guidelines
19:32 Unlock Excel VBA and Macros Course - From Beginners to Advanced
𥻠Sample Workbook used in Last LectuređĄ»
www.xelplus.com/excel-vba-to-c...
The Article : www.xelplus.com/the-visual-ba...
â â Links to related videos: â â
Excel dynamic macro to copy data from one sheet to another: âą Excel VBA: Copy Data f...
âĄïž Join this channel to get access to perks: / @leilagharani
đâ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
đ Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
đ„ RESOURCES I recommend: www.xelplus.com/resources/
đ©Letâs connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#ExcelVBA
Get access to the full Excel VBA Course here đ www.xelplus.com/course/excel-vba-excel-macros/
Leila Gharani if you can make videos on the following topics that would be great -
1. Arrays
2. Class Modules
3. Complex UDFs
Leila Gharani welcome back ur hience
Oh k sure
Nice list - ok arrays and custom functions are in the course - I'll pick one or two lectures and post them here once we cover the basics a bit....Class modules is something I'm planning to add in later and I'll make a note to make a video for CZcams as well.
Leila Gharani how can i. connect with u
Great work on VBA Editor!
Many thanks Mike :)
This is awesome. I am already loving the way it is explained. Thanks a lot Leila!!
You're a talented teacher. Thank you for making this video.
I watched several of the videos about this topic. yours are the most precis and easier to understand. I appreciate you awesome work, and I will definitely recomment your videos to my class.
Thank you for sharing this video. I had some basic tasks to do, without any VBE experience, and your setup instructions got me going the same day.
Thanks Leila. I think that the following videos will be very interesting for me. I love this already :)
Great! I'm glad to hear to hear that John :)
Just enrolled for the VBA course and already loving it. Thanks! đ
Great to hear!
Trust me leila this is the best start for me. Thanks!
Thanks Leila for never make me disappointed for following u.i am already sure that this vba series will be awesome and who knows maybe this time i ll also learn đ
I'm glad to hear that! I'm looking forward to some of your macros :)
Thank you Leila, it was a very clear and direct to the point lecture. I will look for more in your channel.
Great ! VBA coding is what I've been waiting to learn from you since long time ago.
Glad you like it Saroj :)
Thank you so much for the VBA introductory video! You made it easy for a rookie like me
I'm glad to hear that! Thank you Sara.
Thank you for your amazing work. I've just bought one of your courses on Udemy on Excel Dashboards and I am super impressed. You truly have an amazing, God-given gift to explain in such a way that anyone can understand. Keep it up and be blessed in all that you do!
Glad you like the course Frikkie.
Again you are on the top. Excellent way of explanation, especially for beginners.
Thank you! Glad you like the explanation. Thanks for your support.
Excellent and crystal clear explanation!
Full of admiration for all your videos
Thank you Charles! Glad you like the tutorials.
Great Video Leila! :) Subscribed!
Awesome videos by you. I like all of them. Thanks for helping hundred of thousands of people.
I'm glad the videos are helpful.
Very comfortable approach including your physical appearance. Thanks Leila.
You're welcome Maru.
I love your videos. You're the best! Awesome tutorial. Thanks a lot
Thank you very much Leila. You took a lot of mystery out of VBA code writing.
Glad I could help with the Demystification :)
You are a great teacher. Thank you for making this video series.
Thanks for watching!
Thanks Laila for starting this VBA tutorial. Expecting to learn great VBA from your great tutorial in coming days :)
You're very welcome. Yes will be posting more soon :)
Thanks Leila. I've been waiting for some VBA stuff from you. It is a topic I stumble through. :)
You're welcome. It does take some time to get the hang of it....but it's really fun once things start to make sense :)
Love Love Love as usual!!
WOW!
Thank U !! Love your training style
Thanks so much! Very easy to understand and follow.
i love you Leila! you are one of the best teaching excel!
That's really kind! thank you. I'm glad you like the teaching style.
Your video on Excel VBA is rocking. Keep it up!
Thank you! Will try my best :)
Hi mam ur way of teaching is so nice. I m from Pakistan and by watching ur videos I have become a master in excel
Thanx a lot
Your method of teaching is awesome and easy to understand even for non-English persons
Very effective style of teaching. I learned some nice tricks here. Thanks a lot !!
My pleasure. Glad it's helpful.
Excellent teaching skill, use easy to understanding methods...every lesson for vba as well as excel are very easy to understand...thank you mam...
thank you so much !!! i just realize how important vba is in real work life, wish i studied harder about it when i was in school
You're welcome. It's never too late to learn...
Hi Leila, your explaination and presentation is very good.
Thanks Leila your videos on excel had helped alot
You have the best videos on CZcams!
thank you so much for starting VBA because it's my weakness in excel and i'm sure you can explain it better and easier.
You're very welcome Ismail. I hope to explain it as simple and easy as possible :)
thank you mam for vba tutorial uploaded.
Thank you so much Leila... This video is just amazing and so useful! I think I got the easiest way of dealing with VBA... Thanks!
You're very welcome Marcel! Thank you for your comment & support. I'm very happy to hear you find the video useful and easy to follow :)
Love so much Leila... Thanks to you I toy with Excel like a pro. Thank you so much again!
Another good lesson!! thank you
Thank you very much Leila. Best instructor
You're welcome & thank you. That's really kind Jonas!
ParabĂ©ns Leila pelo conteĂșdo.
Thanks Leila your teaching style is good
You're welcome. Thank you! Glad you like the teaching style.
I like your channel. Your contents never grow old. Kudos.
Glad you like them!
Thanks Leila for this excel VBA course.
You're very welcome Samuel.
Thank you very much Leila
Great work
VERY helpful and clear explanation ...
Thank you Leila Gharani you're so great and bright ..
Glad it was helpful!
@@LeilaGharani
what the ...
I'M NOT EXPECTING YOUR REPLY YOU DON'T KNOW HOW HAPPY I AM RIGHT NOW Leila đ đđđđ
Amazing work leila
Good video so I can understand how to build and edit VBA. Thank you.
You're very welcome :)
Cool... Now it Started for which I'm waiting for 'VBA". Thanks for ur video
You're very welcome. Yes finally :)
Thanks for uploading this...need more of this!
You're fast :) I'll put out more for sure. Thanks for the support.
Leila Gharani :-)đ
Always follow your videos....so helpful they are and very very well explained too!
Thank you so much for the videos!
Your videos are the best.
Glad you like them Peter!
Hi Leila.
It was really a great video.. Thumbs Up ...... I hope next videos will also be like this .. great job done..
Regards
Very useful. Thank you!
Glad to hear that!
Thank you very much for the video, very helpful.
My pleasure Mauricio. Glad the tutorial is useful.
Hi Leila awesome! Thanks for this videos, its helped me a lot
I'm glad to hear that.
I already know it will awesome. I've liked already.
Wow! That was fast! Thank you for the trust :)
Great presentation. I can do programming but didn't have in depth understanding of basics.
thanks leila keep it up ur video really really really useful not only for learning purpose although i use ur trick for my dashboard and GL and PL account
You're welcome. I'm glad you use one of the tricks for your dashboard.
EXCELLENT, I thank sincerely for publishing this video on VBA. Your style of explaining the things/concepts, very very informative, inspiring, revealing, thought provoking , interesting & injects a love spirit to learn Excel/VBA for faring better officially/personally. I pray the almighty to bestow good health, prosperity and let more number of people learn the Excel/VBA and do good to the society at large. BIG SALUTATION FROM THE BOTTOM OF MY HEART TO MY LOVELY AND BEAUTIFUL TEACHER. NAMASKAR.
Thank you very much Gopala for your very kind comment. I am very happy to hear you enjoy the tutorials & find them useful :) Thank you for your continuous support.
great interduce.. i will follow it
All hail Leila!
Im in love with this channel
I learned some of this (and quite a bit of different stuff) while using Enterprise 6.0. - Mind you, that is more for creating applications has a whole and it has a compiler for it (to use when it has been debugged and is ready for distribution). - Still, very good (useful) information.
Thank you Leila for the great tutorial! Are there any videos how to create a pop up labeling or hover over on scatter plot graph?
Thanks for video!
Thanks a lot. Please upload more on VBE for beginner.
You're welcome. Yes, sure. - I'll post a few videos on these from my course.
You are the best đ
You're a very good teacher. Thank you. Do you know if Microsoft will ever update the programming in excel to have C# as well as VB?
Very good lesson
You are a star.
THANK
Have taken the course on Udemy as well. Thank you for the amazing material..!
That's great. Thanks for your support.
Hi Sandeep, was Udemy course was helpful ?
Nice!!
seems like the VBA series has finally started as promised back in December :)
Yes. It took a while but it's finally here. I had to structure the original course first so I could also post videos here in a way that was easy to follow... but once the course is out, I'll have time to make separate VBA videos just for the channel here. Let me know if there are any topics you'd like to cover.
Hi Leila.Thanks for the tutorials,indeed they are useful.I want to learn how to generate a user form with drop down list in excel 2016
Hi Lubega - I have this topic actually included inside the course. I'll see if I can add a few of the user form videos on CZcams as well...
Liked the video and subscribed instantly...
Thank you. It's great to have you here.
Excellent
you are amazing
Thanks LG
I am really interested for VBA
I am confident make better future becoz of LG
Thanks a lot with love â€ïž
You're very welcome Dev. Yes - VBA can do great things and it's also lots of fun :)
Great Tutorial! You are always impressive. Can you please make a tutorial on EXCEL VBA Web Form Automation? This will help us a lot.
Enjoyed the Video
Glad you like it Richard.
Thank you.
Is an great and use full to us
Thanks a lot madam
Hi, I have a rather difficult question: I got a file Excel with activation macro. I use many conditional formatting and I wish that the interval of application would remain unchanged. I think that the problem are the macros but I obtain no effect registering a macro and setting the conditional formatting. Do you have any ideas? Thanks
your videos are nice and i love it. i would love to see your VBA course in Udemy
Thanks! Glad you like them. Looking forward to your feedback on the course.
Thanks a lot
Alhamdulillah.
Thank You Leila.
It would be amazing if you do a beginners intro to cross application referencing using excel VBA! Great videos. Keep it up. 100k Subs soon hopefully
Thanks for your suggestion. I cover connecting to PowerPoint, Word and Outlook inside the course. I'll see what I can put on CZcams here as well.... I'm also glad to hear you like the videos. 100k subs or not.... I'll be happy if a few people happen to benefit from the videos :) Thank you for your support.
Court, are you talking about API programming? Like connecting VBA to other apps/technologies?
Grand Welcome... We're also waiting for your classes in you tube channel for VBA Class starts from basics of arrays and modules...
Hello Leila do you recommend saving the macro in a excel file.
Great intro video! Would you have one on docking/resizing the vbe windows. I have managed to "undock" them and they overlap now. The check boxes are all marked under Tools>options as being docked, but they are not snapped in. I've tried resizing them and while functional, they just look messy. :P
Subscribing love it.
Glad to have you aboard :)
NICE VIDEO
Thanks Leila
You're very welcome Robert.
hi Leila, what is the difference between intellisense (pressing control + J) and complete word (pressing control + space). do they behave the same way and autocomplete the same things? i only use intellisense and sometimes some things are not autocompleted or don't show up in the intellisense list, or no list is displayed at all despite the code is accurate
The socratica of Excel!!
Laila jan you are the best ..I am proud to be one of your online student. Mamnoonam
đ
What is the use of ctrl+f11 (macro sheet) which look slightly different from normal excel sheet
Hello Leila, I am trying to run macros to multiple sheets but all of them shares the different format. Is there any way I can record my macro with keyword?
Thank you,
Well done
Thank you Mehdi. Glad you like it.