Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)
Вставка
- Опубліковано 8 лип 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 UA-cam 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.
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 :)
Love Love Love as usual!!
WOW!
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.
Trust me leila this is the best start for me. Thanks!
Great Video Leila! :) Subscribed!
Thank you Leila, it was a very clear and direct to the point lecture. I will look for more in your channel.
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 so much! Very easy to understand and follow.
Another good lesson!! thank you
Thank U !! Love your training style
Just enrolled for the VBA course and already loving it. Thanks! 🙂
Great to hear!
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.
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 :)
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 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.
I love your videos. You're the best! Awesome tutorial. Thanks a lot
Excellent and crystal clear explanation!
Full of admiration for all your videos
Thank you Charles! Glad you like the tutorials.
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.
Again you are on the top. Excellent way of explanation, especially for beginners.
Thank you! Glad you like the explanation. Thanks for your support.
Thanks Leila your videos on excel had helped alot
You are a great teacher. Thank you for making this video series.
Thanks for watching!
Very comfortable approach including your physical appearance. Thanks Leila.
You're welcome Maru.
Thank you very much Leila. You took a lot of mystery out of VBA code writing.
Glad I could help with the Demystification :)
You have the best videos on UA-cam!
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 :)
Awesome videos by you. I like all of them. Thanks for helping hundred of thousands of people.
I'm glad the videos are helpful.
THANK
Thank you very much Leila. Best instructor
You're welcome & thank you. That's really kind Jonas!
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
Thank you very much Leila
Great work
Your video on Excel VBA is rocking. Keep it up!
Thank you! Will try my best :)
Excellent teaching skill, use easy to understanding methods...every lesson for vba as well as excel are very easy to understand...thank you mam...
Parabéns Leila pelo conteúdo.
Amazing work leila
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...
Thanks Leila for this excel VBA course.
You're very welcome Samuel.
Thanx a lot
Your method of teaching is awesome and easy to understand even for non-English persons
You are the best 👍
You are a star.
Very effective style of teaching. I learned some nice tricks here. Thanks a lot !!
My pleasure. Glad it's helpful.
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.
Hi Leila, your explaination and presentation is very good.
Thanks Leila your teaching style is good
You're welcome. Thank you! Glad you like the teaching style.
Thank you very much for the video, very helpful.
My pleasure Mauricio. Glad the tutorial is useful.
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!
Your videos are the best.
Glad you like them Peter!
Thanks for video!
Very useful. Thank you!
Glad to hear that!
Very good lesson
I already know it will awesome. I've liked already.
Wow! That was fast! Thank you for the trust :)
Good video so I can understand how to build and edit VBA. Thank you.
You're very welcome :)
great interduce.. i will follow it
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!
Hi Leila awesome! Thanks for this videos, its helped me a lot
I'm glad to hear that.
Nice!!
All hail Leila!
Im in love with this channel
Excellent
you are amazing
Thanks a lot
I like your channel. Your contents never grow old. Kudos.
Glad you like them!
Cool... Now it Started for which I'm waiting for 'VBA". Thanks for ur video
You're very welcome. Yes finally :)
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.
Thank you.
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.
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 😅😘💞💋😍
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?
Is an great and use full to us
Thanks a lot madam
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?
Hi Leila.
It was really a great video.. Thumbs Up ...... I hope next videos will also be like this .. great job done..
Regards
Great presentation. I can do programming but didn't have in depth understanding of basics.
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
Enjoyed the Video
Glad you like it Richard.
Alhamdulillah.
Thank You Leila.
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 :)
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 VIDEO
Liked the video and subscribed instantly...
Thank you. It's great to have you here.
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.
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.
Subscribing love it.
Glad to have you aboard :)
Thanks Leila
You're very welcome Robert.
What is the use of ctrl+f11 (macro sheet) which look slightly different from normal excel sheet
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.
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
The socratica of Excel!!
Well done
Thank you Mehdi. Glad you like it.
How make search box which display all search value and it's associated data in same row. It should include all duplicate values.
Hello Leila do you recommend saving the macro in a excel file.
i need help in writing to a file and userforms together with their codes
thanks
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,
HI Mam Cna You Help Me How can see any code in VBA Protect sheet
thanks thanks thanks
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 UA-cam as well...
Grand Welcome... We're also waiting for your classes in you tube channel for VBA Class starts from basics of arrays and modules...