VBA For Beginners: Mastering Variables Like A Pro

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.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

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

EXCEL COURSES:

EXCEL PRODUCTS:


Follow me on my Social Media Accounts:

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:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

#vba #excelvba #Vbaforbeginners #Excelforfreelancers #variables

[tahiryfanambinanarafidiman]

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!

[JanBolhuis]

I discovered this channel a few weeks ago and I must say I am already a fan. And for now: starting the acadamy masterclass 💪

[tylersmith]

Wow, someone i can actually follow! Thank you. Yeah you are the best out there I think.

[pramodparnami]

DIM is *Declared_In_Memory* regards from New Delhi 🇮🇳🇮🇳

[Michael-Hubbard]

Wow!! I can finally Understand Declaring Variables. Thank You Randy for Your hard work teaching us .

[MegaTimPim]

It was an excellent use case to demo how variables and loops work. Loved it.

[adebowaleadewale]

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.

[AraRoodbuik]

Clear language, understandable, educational and well explained. Thank you for this fourth lesson on Saturday.

[michaelmaharlika]

Awesome, enjoyed this simple variable lesson, thanks Randy.

[ImranKhattak-melw]

Hi Randy, I really understand from your videos, thank you sir

[nairobi]

Nice video. I included another variable to avoid manually typing in the last row, 6 in your

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...

[Gmalo-vb]

Thanks a lot, Sir!!
Please keep sharing similar beginners' videos as your way of teaching is amazing.

[rashadulislam]

Thank you sir for your good effort to listen to us about vba for beginners.❤❤❤

[satyabanukil]

Wonderful Sir. Can it be done in Access

[tonybarker]

Excel-lent tutorial ! Thanks Randy !!!

[joelabacherli]

Brilliant. Tons of info in such a short amount of time. Thank you for this

[noneyabeezwax]

Randy is the Bomb! Thank you for sharing your knowledge and expertise.

[IvyPlans]

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.

[silverlicious]

Very helpful. Please continue the VBA Videos

[MBJazzful]

Thanks, Randy. I used some VBA, but nothing as clever as that. I can already see a project...