Getting Started With Excel VBA: Step By Step Tutorial For Beginners
āļāļąāļ
- āđāļāļĒāđāļāļĢāđāđāļĄāļ·āđāļ 2 āļ.āļ. 2024
- ð BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! ð rebrand.ly/FreelancersAcademy...
ð GET A DISCOUNTED DEVELOPERS LIBRARY HERE âš rebrand.ly/UDVL_YTDesc
ðĨGET 300 OF MY BEST TEMPLATES HEREâš rebrand.ly/300Wkbks_YTDesc
ðĪBRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN âš rebrand.ly/AIToolpack_YTDesc
ðCREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM âš rebrand.ly/MentorshipProgram_...
âķïļ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
ðĻâðžBECOME AN EXPERT AT DASHBOARDS âš rebrand.ly/ExcelDashboard_YTDesc
ðĢSTART LEARNING VBA HERE âš rebrand.ly/VBAEFFDan_YTDesc
ðBECOME A SUCCESSFUL FREELANCER âš rebrand.ly/FreelancersAcademy...
âïļJOIN TH-cam MEMBERS FOR UNRELEASED TRAININGS âš rebrand.ly/YTMembership_YTDesc
In this brand-new weekend series, I will be creating step-by-step Excel VBA tutorial videos for beginners to give them all of the tools, tips, tricks, and techniques to be able to master VBA and create their own Excel applications in no time at all.
âŽDOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/VBABasics_WkbkDl
ðĪ START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM ð rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
âšFREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
âšMENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
âšDASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
âšBEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
âšWEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
âšTurbocharge Your App Development: rebrand.ly/UDVL_YTDesc
âšGet 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
âšGet ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
âšThe Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
âšGet Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
âš1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
ð§Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
1:14 - Why is VBA important
3:42 - Getting Started with VBA
4:14 - Displaying The Developers Tab
6:32 - Mastering the Visual Basic Editor
10:56 - Our First Macro
18:51 - Clear Cell Contents
21:31 - Recorded Macro
22:40 - Saving Workbook
24:04 - Declaring Variables
JOIN OUR COMMUNITY:
âšFacebook Group: rebrand.ly/EFF_Group
âšFacebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
ðĪĐTikTok: / excel4freelancers
ðĶTwitter: / excel4freelance
ðWebsite: www.ExcelForFreelancers.com
ðLinkedIn: / excelforfreelancers
ðĪFacebook: / excelforfreelancers
ðļ Instagram: / excelforfreelancers
ðĨRumble: rumble.com/c/ExcelForFreelancers
âTelegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
ð / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
ðĨ Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! âš bit.ly/FreelanceAcademyYtCom
This is a series that I am waiting for. Because most of the videos I downloaded is too technical for my understanding. Please from scratch would be appreciated. If you have done one in the past please send a link. Much loveâĪ
Yes Emmanuel. To be honest, I felt that so many people had basic VBA videos so there was no need. However, my followers asked so much for me to create the series, so I am really happy to bring it to you.
I also have a 'from scratch' video coming out next Tuesday right here:
th-cam.com/video/e7tUsgWh3Uw/w-d-xo.htmlsi=pZ3s4xD33kgUs3D1
Thank you for your Likes, Shares & Comments. It really helps.
All thumbs up to the greatest VBA youtube teacher. Thanks a lot Randy for all your hard work. Hope people subscribe as i already did ð
Thank you so very much, I really appreciate that Jojo. Very kind of you.
Thanks, Randy, for this wonderful series. I have been waiting for it forever. Your efforts are much appreciated.
Thank you so very much, I really appreciate that. I am glad to help and share.
Thank you, Mr. Randy. What you are done is remarkable. I appreciate you.
Thank you so very much, I really appreciate that and your continued support
Thank you for starting this series. You do a wonderful job.
For sure, you are very welcome and so happy to help and share
This lesson was brilliant. You've really explained these basic concepts very well. Thank you so much.
Great, thanks so very much. I am happy to help and share
The best Excel learning Channel. Thanks for all the Staff
Thanks so very much. I really appreciate that
This lesson is great. I look forward to future lessons like this. You made VBA as easy as ABC.
Thank so much. Yes every Saturday I will be sharing new VBA For Beginner trainings. Thank you for your Likes, Shares & Comments. It really helps.
Wow! ðēðĨ
Short and concise and crafted with great care for beginners!!
Thanks for the hard work and dedication Mr Randy!!
My pleasure, and so glad you enjoyed it. Thank you for your Likes, Shares & Comments. It really helps.
thanks sir,
am waiting for your whole series, hopefully this will be a great journey .
thanks for this pertinent work.
Thank you so very much, I really appreciate that and I am happy to help and share
I love this. Thank you.
That is great thanks so very much
Thank you very much Randy. This lesson was helpful.
For sure, you are very welcome and happy to help and share
Love this series, sir. Hope this series will be fruitful for me and other newbies like me.Thanks once again for this series.
Thank you so very much, I really appreciate that. You can find all of the new videos for VBA Basics on this playlist th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
Thanks Alot mr.Randy we are so Happy with your support
And we started learningâĪ
That is so great. I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
I am new here!! Although I don't usually comment on videos, this channel is by far has the most in depth tutorials that are taught beautifully. Thank you very much!!
Thank you so very much, I really appreciate that and so great to have you here
I recommend this video from a beginner standpoint (which I am)..this is my first learning video that I a have finished without hoping to some other distractions.ð
WOW that is really Excellent. I am very happy to hear that. Thank you for your Likes, Shares & Comments. It really helps.
tthanks alot for this great great lesson. looking forward the next one
Thank you so very much, I really appreciate that. I am really glad you enjoyed this. Each weekend will be a new one. Thank you for your Likes, Shares & Comments. It really helps.
Thank you very much for this new Series, you always share your knowledge with others and it is very valuable
Thank you so much for your kind words! I'm glad you find the new series valuable. I always strive to share my knowledge and help others.
Thank you randy. This is what I waiting and find.
That is great. So glad I could help.
Thanks so much. Appreciate your work
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Thanks Randy for this video.
For sure, you are very welcome Syed. I am happy to help and share
DIm: Declare in memory..that is going to stick for sureðThank you for these incredible videos...
Excellent. I am really glad I could help. Thanks again for your continued support.
Super. Desde cero. Super Saturday 4 me. Now I will have the best of advanced and the best teacher from start... tks so much. Espero seguir creando mis programas de trabajo en Vba
Thanks so very much. I am really happy to bring this new series to you each and every weekend
Thanks Randy!!!! :) :) This is something that I always wanted.......starting from scratch. I do not know any VBA, so this will help. Thanks again!!! :) :)
For sure, you are very welcome and so glad I could help
This is great, I hope to learn for your more advanced courses
Thank you so very much, I really appreciate that
Great stuff!
Thank you so very much, I really appreciate that Hillary
Thanks a lot Randy.
For sure, you are very welcome and happy to help and share
Excellent Video. I would appreciate it if you continue this tutorial and make it up to the intermediary level as a series tutorial.
Hi and thanks so much. Yes I will continue this each and every Saturday. I will also continue intermediate to advanced every Tuesday as well. Thank you for your Likes, Shares & Comments. It really helps.
Looking forward to itð
Great, thanks so much. I am happy to help and share
I am struggling from many days in VBA For this new series i am so thankfull to you âĢâĢ
For sure, you are very welcome and happy to help and share
Cool video! Keep it up! ðð even though my laptop is struggling while i am learning vba
Thanks so much. I am happy to help and share
My hero. Thank you, Randy & Team.
~Tammy
NC
Thank you so very much, I really appreciate that Tammy. Make sure to catch the 2nd video in the series coming this Saturday. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers âĨïļâĨïļ
Really looking forward to this series and I like your other videos. I was wondering what differences there may be if using Excel for Mac. I know there are difference with things like power query and others. Thank you! Mark
Hi and thanks. Mac's are limited with Excel & VBA, so if I had a choice, I would go to with Windows. You can find more information on Excel VBA for Mac here: www.macexcel.com/
I hope this helps and thanks so much.
Informative video and explained in lucid manner.ð
Thank you so very much, I really appreciate that
More than great .if you please, need more videos VBA and User formsvv
Hi and thanks, yes for sure I will be creating a video on basic userforms in the near future in this VBA Basic series
I hope this helps and thanks so much.
Hola Randy, emocionado de conocer vba, me sorprende lo que haces y espero que pueda lograrlo con las tutorias que impartirÃĄs, saludos y a la espera de
de los tutoriales...
Muchas gracias, realmente aprecio que JesÚs
Brilliant Sir. Thank you
Thank you so very much, I really appreciate that
thanks for everything.. great.. I love it
...from Iraq....
Thanks so much. I am glad to help and share.
Great work and explanation...
Thank you so very much, I really appreciate that and I am excited to share this series with everyone. Make sure to share and subscribe
Hi Randy .. thanks for this and I am sure this is for everyone who wants to become more productive and efficient. Thank you.
Thank you so very much, I really appreciate that Neren. These trainings are probably well below your skill level, but a lot of people have requested these trainings. Of course I will stil be doing the intermediate to advanced every Tuesday. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy ... I am not advanced ðĒ Saldy even watching lots of tutorials, it's the way it is presented. I was hooked on your training years ago because of the layout and format and still love them to this day. This training, people need to know what is possible using VBA. Thanks Randy
Awesome Neren. Thanks so much for your continued support.
Thank you
For sure, you are very welcome and I am happy to help and share
Great for sharing
Thank you so very much, I really appreciate that
Waiting for this series so long, and am really excited , as well as will be soon in ur ultimate vba course just have some issues these days âĪâĪâĪ
Thank you so very much, I really appreciate that and look forward to having you. Much appreciated (Just a little hint, we have a great Black Friday promotion coming in 10 days)
I hope this helps and thanks so much.
@@ExcelForFreelancers Is the ultimate vba your course? I saw the sales page saying Dan. But I remember you name is Randy?
Hi and thanks so much. This course is from Daniel Strong. He was my mentor in VBA and I since he has such a great beginners VBA course I have partnered with him on this to help share his course. I hope this helps and thanks so much.
Very nice ð
Thank you so very much, I really appreciate that
Very useful information
Great, thanks so very much
waiting you in every Sunday ð
Great thanks so very much. I appreciate that.
Recently I start following you and find your channel very informative. I have a question that which version of office your using?
HI and thanks so much. On all of my videos in the last few years I am using Office 365, however you can use any version you like, as my trainings can apply to any version in the last 20 years. I hope this helps and thanks so much.
Great ð
Thanks so very much, Tarek. I am happy to help and share.
Thank you very much for such amazing video! Iam watching from Kurdistan :)
For sure, you are very welcome and I am happy to help and share
This is excellent Randy.
By the way, you mentioned Intermediate Training? Is that the Tuesdays training?
Hi and thanks so much Raymond. Yes, correct. Tuesday's will still be intermediate to advanced trainings were we will amazing applications in Excel. Thank you for your Likes, Shares & Comments. It really helps.
Great video Please make a tutorials video how to connect excel to msword, powerpoint, visio etc(define object as to open application and execute macro in orher application like ms word powerpoint visio etc
HI and thanks, Its a nice idea and I have added it to my list of videos to create in the near future. thanks again
Thanks so much excel for freelancer
For sure, you are very welcome and thanks
Hello, all your videos are excellent. May I know what screen recording software you use?
Hi and thanks so much. I am using Camtasia Studio. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thanks
Thanks for sharing! What is the next video from this?
Hi and thanks very much. You can follow this playlist which will always have all of the Basic VBA Training, in order:
th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
Hello Randy, how are you? i thanful to you to create this VBA series. I really need of this.
For sure, you are very welcome and thanks for your feedback
Beyond excellent tutorial. How do we know when to declare a variable?
Thank you so very much, I really appreciate that. Variables are great when you want to reuse, or keep track of data. Variables are also a visual way to remember the data stored inside the variable. Since you commented on my training on 'Mastering Variables' that just came out, you saw that one already. So that training is focussed on just variables.
I hope this helps and thanks so much.
Very interesting initiative to master the world of Macro and VBA files online. I would find it even more useful if the downloadable template also included a "Word or PDF file". Learning purely from the video is too fast for me to really let it sink in. But it's just a suggestion. Thank you very much for this first lesson.
Thank you so very much, I really appreciate that Ara. I will always make the Excel file available for download and will consider a PDF as well. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy. Can you share the link to Daniel Strong's VBA course? Thanks.
Hi sure you can learn more here: bit.ly/VBACourseYTDesc
Thanks so much
Perfect explanation!âĶ.but am not able to save vba project every time I reopen the code is missing and I have to rewrite it . While saving its showing âThe following features cannot be saved in macro-free workbook" warning dialogâ then clicked save yet itâs not working please provide me with a solution
Hi and thanks for your comment. The file must be saved as an ".xlsm" file to preserver the macros and not an xlsx file type. I hope this helps and thanks so much.
Do you offer excel classes starting from square one all the way up to advance? Meaning if I just started using excel and I donât know how to do anything aside from loading the sheet up and want to learn everything. Do you offer those types of classes as well?
Hi and thanks. Yes for sure. You may want to consider enrolling in Daniel Strongâs Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared
Also, in my Mentorship Program, which is on sale this month, I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
I hope this helps and thanks so much.
Hi, very interesting videos indeed... I made years ago vba files with a calendar in userforms. This ocx cannot be added in new excel versions and doesn't exist anymore in new excel. I've found an userform in internet that do the same work. But is it possible to insert an userform in an userform ? Do you know other solutions ? Thanks for your videos very useful...
Hi and thanks, yes sure its certainly possible. Le'ts assume you have a userform with a date field and you want a date picker to pop up, you can have this. Just set the Show Modal to False on the first userform which will allow the 2nd to be shown. I hope this helps and thanks so much.
Can we go with click on item image to item data with use through vba code in excel.
(like amzon or flipart)
Hi and thanks very much. Yes sure this can be done. Please search my channel for 'Schedule' as I do this in many videos. I hope this helps and thanks so much.
Hi, can I get the Variables types so I can check it out and learn
Hi and thankms, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Where can I ask questions about the programs currently sold on the website? I am wondering if the excel mentorship mastermind is also for beginners who only know the most basic VBA.
Hi and thanks so much. I have a single course that is for beginners and it is from Daniel Strong, called the Ultimate VBA Course and you can find it here: bit.ly/VBACourseRandyShared
I also have this on sale for 50% off for Black Friday.
I hope this helps and thanks so much.
Sir Please Teach Ms Access ð
Hi and thanks for your comment. I am only focused on Excel at this time. Thank you for your Likes, Shares & Comments. It really helps.
If i download Excel have codes how to see those codes and data i have an excel sheet with codes and i wants to develop and make new things but i I need some of those codes inside it i tried many ways to see but not succeed ?
HI and thanks very much. You can press Alt + F11 to see the codes. This is the shortcut to view the VBA Editor.
I hope this helps and thanks so much.
When creating the first macro, what does Option explicit mean and must I type it in before typing the code for the macro? 12:05
Hi and thanks very much Option Explicit, means that you are required to declare all variables in your code. In the VBA Editor Tools > Options > check the 'Require Variable Declaration' option, then any new module you add will have this Option Explicit text already at the top.
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks for the explanation. I am really liking the beginner series and learning a lot in the process. It's the best of all the ones I have tried so far.
That is great to hear and thanks so much
Hi, what's option explicit mean?. Thanks
Hi and thanks, it means that Variables are required to be declared. We will go over that specifically next weekend. Thank you for your Likes, Shares & Comments. It really helps.
VBA learning still important?
Can I do this by copilot 365 and ai tools?????
What should I do
Yes absolutely important. I go over the 'Why' in this video. I also have a video on how to create an application with ChatGPT here: th-cam.com/video/0hF6zR7APUs/w-d-xo.html
I hope this helps and thanks so much.
Just FYI - It's very difficult to be a Mac user for Office. I have to use my old Macs to create dialog boxes. Really?? Does MS not realize Mac users are customers, a.k.a. a source of money?????
Yes I agree with you. The issues between Microsoft and Apple go back many, many years. It's extremely frustrating for users.
None of your links are open. I can't access the course.
Hi and thanks. I have checked all of the links and they seem to be working fine. You may have a firewall or some protection preventing you to reach the destination.
You may want to try from another location or computer
Is your lectures available in URDU LANGUAGE or URDU translation???
Hi and thanks so much. Yes I do have subtitles in URDU for every training. I hope this helps and thanks so much.
Can you help me resolve an issue? I got the free workbook in my email but Bitdefender tried to block the link because it said it was an untrusted webpage. Also, after I downloaded the workbook, Excel has a red bar at the top and says Microsoft has blocked the macros because the source of the file is untrusted. Excel won't even let me mark the file as trusted. Any ideas?
Hi and thanks very much. I can assure you it is safe as I have programmed it myself. Bitdefender get's a log of things wrong. Concerning the red bar, as an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@ExcelForFreelancers It does help and thank you.
Mine only displays sheet 1 and this workbook.
Hi and thanks for your comment. You can press Alt + F11 to get into the Visual Basic Editor.
I hope this helps and thanks so much.
I need help in excel
Hi and thanks. I am very happy to help. I will be creating these tutorials each and every Saturday. It will be great to have you join us. Thank you for your Likes, Shares & Comments. It really helps.
Phyton was coupled with !! Beter
Thanks so much. I very likely may get into Python training in the future if enough people request it. Thanks for your support. Much appreciated
@@ExcelForFreelancers Me.. I like to learn the python automation with excel.
Is Microsoft going to kill off VBA?
Absolutely Not. I address this in the video. Thanks so much for watching.
How to caption translate sinhala
Hi and thank you can click the CC to show the captions and subtitles. I hope this helps and thanks so much.