VBA For Beginners: Mastering Variables Like A Pro
ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 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 training for VBA Beginners, I share with you the basic concepts of variables within VBA and how powerful they can be to use within your application. We go over several variable types, step by step, so you can become an expert in no time.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/MasteringVariables_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
0:38 - What is Variable (5 common variables)
5:14 - Pay Employees
5:29 - Declare Variables
16:51 - Print Out
19:52 - Run A Loop
20:51 - For Next Loop
23:48 - Things We Learned
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
#vba #excelvba #Vbaforbeginners #Excelforfreelancers #variables
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
Nice video. I included another variable to avoid manually typing in the last row, 6 in your case.....
after Dim EmplRow As Long 'Whole Number Variable add the following
Dim LastRow As Long
LastRow = EmplSht.Cells(EmplSht.Rows.Count, "B").End(xlUp).Row
And instead of 6 write "LastRow"
With EmplSht
For EmplRow = 3 To LastRow
As the subject is variables, I thought this would fit...
HI and thanks, Yes for sure. I was about to do that as well, but I am really trying to keep these initial videos very basic. Thank you for your Likes, Shares & Comments. It really helps.
The title said "Mastering Variables Like A Pro" but by the end of the video we learned much more than that: With statement, if statement, for next loop, printout.
The example is just perfect for the practice. A really big 👍for the tutorial Randy. Thank you!
Thank you so very much, I really appreciate that. I try to pack in as much value as possible in these videos. I also have dedicated videos on If/Then statements and For/Next loops.
Check out all of the basic VBA videos here: th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
Wow!! I can finally Understand Declaring Variables. Thank You Randy for Your hard work teaching us .
For sure, you are very welcome Michael, I am really happy I could help and share.
please continue the beginner course
Yes for sure I will. Each and every weekend I will have a new video on VBA for Beginners. Thank you for your Likes, Shares & Comments. It really helps.
It was an excellent use case to demo how variables and loops work. Loved it.
Great and thanks so much. Soon I will have a dedicated lesson on loops as well. Thank you for your Likes, Shares & Comments. It really helps.
I discovered this channel a few weeks ago and I must say I am already a fan. And for now: starting the acadamy masterclass 💪
Wow Great. Welcome Aboard Jan. Great to have you and thanks so much for your support.
Clear language, understandable, educational and well explained. Thank you for this fourth lesson on Saturday.
Great, thanks so much. I am really happy to bring you this new series each weekend. Thank you for your Likes, Shares & Comments. It really helps.
Thank you. We are loving it!!!
Great and thanks so much. I am happy to help and share
This is great. I love your approach. It is very easy for a beginner to actually follow through and learn, even without English being their first language. I can't quantify the value, please keep it up sir.
Thank you so very much, I really appreciate that and happy to help and share
Thanks a lot, Sir!!
Please keep sharing similar beginners' videos as your way of teaching is amazing.
Yes for sure I will, each and every Saturday. Thank you for your Likes, Shares & Comments. It really helps.
Excellent tutorial. Thanks a lot!
Thank you so very much, I really appreciate that Christopher
Thanks Randy for this amazing video.
Thank you so very much, I really appreciate that Syed
Brilliant. Tons of info in such a short amount of time. Thank you for this
Great, thanks so much and I am happy to help and share
Randy, I love your instruction videos . I have been using VBA for quite some time. Is there a way to teach VBA from scratch. I usually use pre written code and change it. This class would be more reasoning behind writing code. For example start with a question than show the process and why of the code.
Hi and thanks, Yes for sure. As this series progresses, we will start with small problems and see how VBA can help us solve those problems. Once the fundamentals are taught in this series. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you
Excellent!!!
Thank you so very much, I really appreciate that Alejandra. Much appreciated
You can download your free Personal Macro Library for this link: bit.ly/PersonalMacro_WkbkDl
Thank you for your Likes, Shares & Comments. It really helps.
Thanx man ...
You are great ...
Thank you so very much, I really appreciate that
Very nice video ! Thank you very much
For sure, you are very welcome and happy to help and share
Thank you sir for your good effort to listen to us about vba for beginners.❤❤❤
For sure, you are very welcome and happy to help and share
Thank you for your help
For sure, you are very welcome and thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, I really understand from your videos, thank you sir
That is really great to hear and thanks so much for the feedback. Thank you for your Likes, Shares & Comments. It really helps.
DIM is *Declared_In_Memory* regards from New Delhi 🇮🇳🇮🇳
Thanks so much :) Thank you for your Likes, Shares & Comments. It really helps.
Awesome, enjoyed this simple variable lesson, thanks Randy.
Great Michael. thanks so much. I will be creating a basic VBA training each and every Saturday from now on. Thank you for your Likes, Shares & Comments. It really helps.
Excel-lent tutorial ! Thanks Randy !!!
Thank you so very much, I really appreciate that Tony :)
Very helpful. Please continue the VBA Videos
For sure, you are very welcome and thanks. I will for sure keep it up. Much appreciated
May I confirm that the commend "EmplRow=3' is for nofity VBA that the process is for Row 3? Thanks. By the way the lecture is awesome!
Hi and thanks very much. Yes that is correct, that means we are assigning 3 to the EmplRow variable. I hope this helps and thanks so much.
Thank you
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Randy is the Bomb! Thank you for sharing your knowledge and expertise.
For sure, you are very welcome and I am very happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
Thank you.
For sure, you are very welcome and thanks so much
Brilliant 👏 👏 👏
Thank you so very much, I really appreciate that
I have seen many people teaching excel. But none of them even close to your work. But if u add pdf explaining the logics used in the workbook separately it will be great. Also describe what is ur logical approach to a workbook
Thank you so very much, I really appreciate that and will do my best to add in logic and use as well. Thank you for your Likes, Shares & Comments. It really helps.
Thanks, Randy. I used some VBA, but nothing as clever as that. I can already see a project...
For sure, you are very welcome I am happy to help and share
excellent
Thank you so very much, I really appreciate that
Please teach Arrays i always face trouble with Array. Thanks regards
Thanks so much. For sure we are going to get into arrays in the very near future. Much appreciated.
@@ExcelForFreelancers thank you Sir
I am in love with you for what you are doing.❤❤❤❤
Thank you so much for your kind words! It means a lot to me that you appreciate what I do.
I am enjoying watching your series on basic subjects even though I probably know much of the content. But there are still tidbits to pick up. Please consider expanding on the variables issue to include variable scope... to include global, public, static etc. Scope is critical to writing many routines. Also an interesting advanced feature I learned about from Chip Pearson called Hidden Name Space that allows you to set a variable in one workbook, close it and open another workbook and retrieve it's value. Not really a scoping issue, but a way to pass variables. This works at the application level and as long as you keep your session open, the variables remain in context. I had an issue with 32 vs 64 bit routines that couldn't be solved with compile time directives (subject for another video perhaps ) and needed separate front ends for a common back end processing program and I created a master that called only the front end routine needed and the data became available from either of the front end programs. Anyway... enjoy all your presentations.
Hi Malcolm. Thanks so much for your feedback and ideas. Very helpful. I have written then down and will certainly consider them for topics in this series. Thanks again for your continued support and feedback.
Hello teacher I help modules not running
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
1st first viewer I'm so glad 😊
Thank you so much for being the first viewer! Your support means the world to me.
soy chingon copiando pero cuando quiero hacer una macro para mi trabajo no la hago
Muchas gracias por su comentario. Para ayudarlo a aprender cómo crear macros, asegúrese de ver mis videos de los sábados en los que cubro la programación básica de VBA aquí: th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
Espero que esto ayude y muchas gracias.
You look like a shaolin monk
Hahaha, sometimes I feel like one. Thank you for your Likes, Shares & Comments. It really helps.
Sub Module()
Dim EmplName As String, Work As String
Dim PayDate As Date
Dim PayAmt As Double
Dim Paid As Boolean
Dim EmplRow As Long
EmplRow = 3
For EmplRow = 3 To 6
With Emplsheet
EmplName = .Range("B" & EmplRow).Value 'Employees Name
Work = .Range("C" & EmplRow).Value 'Work Completed
PayDate = .Range("D" & EmplRow).Value 'Pay Date
PayAmnt = .Range("E" & EmplRow).Value 'Pay Amount
Paid = .Range("F" & EmplRow).Value 'Paid
If Paid = False Then 'Not paid yet
.Range("K2").Value = EmplName
.Range("N2").Value = PayDate 'pay date
.Range("K4").Value = Work 'Work Completed
.Range("N4").Value = Paid 'Paid True/False
.Range("f" & EmplRow).Value = True
End If
End With
Next EmplRow
End Sub
Hi I am getting Error in "Paid = .Range("F" & EmplRow).Value 'Paid" this code and the error is "Type Mismatch" but i am not getting the mistake so please help me i tried a lot to find that mistake but i am not getting.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.