5 Things I wish I knew When I started using Excel VBA

👉 Ready to master VBA?
(Note: If the download page doesn't work then make sure to turn off any popup blockers)

Hello and welcome to this Excel Macro Mastery video. I've been writing code for a long time.

One thing I also try to do when I use a new language or technology is to find the most practical and efficient techniques that I can use.

These techniques are often little-known secrets that only a small percentage of users know.

So in this video, I'm going to show you 5 things that I wish I knew when I started using Excel VBA.

Shortcut Keys:
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + R: View the Project Properties Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.
Tab: To move lines of code to the right(Indent)
Shift + Tab: To move lines of code to the left(Outdent).

Table of Contents:

00:00 - Introduction
00:00 - The Worksheet Codename
02:21 - Current region
04:08 - Copying from Range to Array
06:19 - Using the Split Function
08:57 - The Debug Compile tool

[ChrisShawCDS]

Brilliant! I've been (casually) coding VBA in Excel for >20 years and I didn't know some of these! Doh! Please keep doing "Another 5" videos until you run out of ideas. :) Thank you!

[PJTarver]

This guy is the best out there by far. For anyone trying to learn VBA for Excel, start here.

[elijahkehayias]

I have watched many, MANY! YouTube Videos in order to improve and learn VBA. You are by far the BEST. Explaining the Fundamentals is what teaching is all about, not just "tricks". I am definitely signing Up for your Course. Excel not an easy topic to learn and not every-one has the ability to teach. Thanks for your VIDS. HUGE THUMBS UP.

[gregbernard]

I have been an intermediate VBE coder for years (do not want to be advanced) - but your channel is great.

[adamwstbrook]

The array portion was amazing! I didn't know it could use it like that. Definitely a game changer for me.

[missile-shapedbourbon]

Just knowing that people can't break the macro by renaming the sheet is a dream! Thank you so much!

[houstonsam]

Many thanks for such clear, well-organized, and focused content. I'm the "Excel guy" in my workplace; there are a few YouTube experts I rely on for effective tutoring to increase my knowledge. You're my YouTube subscription for VBA.

[Porconion]

Many thanks. Especially the array part. I shed a tear. Happiness? The fact I wasted so much time in the past? It is just the powerfull simplicity at the end.

[warrenhall]

Paul, Taking a step back to see the fundamentals is an interest tour. I wish I had taken that step almost two decades ago. VERY well done. Thanks. Always a pleasure to "see" you.

[davidlee]

Your videos are so awesome, so well organized. Everyone can tell you put a lot of hard effort and making it so easy to follow and learn. You're amazing and raising the bar for everyone!

[Excelmacromastery]

Hi everyone,


I hope you will enjoy these useful things that I wish I knew when I started using Excel VBA.
Please add any comment or queries below the video.


Thanks all.

[krisyannuruha]

Thank you.. I'm starting to learn VBA and this will help me a lot

[wayneedmondson]

Hi Paul.. thanks so much. These tips are GOLD!! Thanks to videos like this, your excellent web site and blog, and your paid course options, becoming good at VBA is available to anyone willing to put in the time. Thanks for sharing your knowledge and skills.. much appreciated and valued. Thumbs up!!

[afilipppp]

so much time lost finding ranges... glad i clicked this suggested video. ty man

[mangobrother]

Using VBA for 2 decades. I did not know any these. Thanks a lot mate. More please... Cheers.

[grtraders]

Paul,

I rarely comment on any of the youtube videos and just move on most of the time.

However, I just wished to make an exception here.

I just wish to say that by far
you are one of the most brilliant tutors on the internet (that I have come around) in the excel vba arena.

Please keep up the good work. It is a pleasure to watch your informative videos.

Thanks,
Ravi.

[jamesart]

Wow, I have been using Excel professionally for 20 plus years and, damn, just learned 5 new things.
How I managed without knowing this all these years astounds me.
Thank you, thank you, thank you.

[richch]

Paul, I know what you are doing takes a lot of effort to produce. Thanks so much! Your tips are invaluable.

[michaelreese]

I knew all of them, but the way you use the watch window is something I've never seen and now will use more frequently! Thanks!

[blackinktraining]

Great video Paul. I teach a VBA course at a Canadian university and we cover a lot of those techniques. Nice to see someone else setting everyone straight!