The 7 Keys Areas of Excel VBA (with code examples)

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

The 7 Keys Areas of Excel VBA (with code examples)

In this video I cover the 7 keys areas of Excel VBA. If you plan to master VBA then this can help shorten you journey by telling you what exactly to focus on.

This video is full of code examples. Theory is useful but nothing beats the actual code.

If you have any questions or comments please leave them below the video.

Useful VBA Shortcut Keys:
Tab: To move lines of code to the right(Indent).
Shift + Tab: To move lines of code to the left(Outdent).

Shift + F2: Get the definition of the item under the cursor.
Ctrl + Shift + F2: Go to the last cursor position.
Ctrl + Space: AutoComplete Word.
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + R: View the Project Explorer Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F4: View the Properties Window.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.

[sasavienne]

Every time I feel happy when I get an information that you uploaded a new video because I know that it is going to be very helpful and quite useful. Thanks indeed Paul. 👏 🌟 🌟 🌟

[SolidSnake]

This must be some record - 3 days of VBA training squeezed into 28 minutes. Bravo!

[robinhahn]

I've written quite a few apps in Excel VBA (probably using very kludgy code - this was over years before the great resource that is YouTube and excellent videos such as yours, Paul) and am currently in process of revising many of them, only just to simplify the code, clean up the bugs and most probably speed those apps up a bit. Of all the tutorials and videos I've read or seen, yours easily offer the most truly game-changing suggestions! Thank you!

[Whatarewefixingtoday]

My Employer thanks you for making me more efficient!

[MrVicmanr]

Awesome! I'm learning a lot. Thank you for sharing your knowledge.

[eddai]

Hi Paul. It's amazing knowledge. Thanks for sharing.

[LordBransty]

You're a very gifted educator Paul. I've been programming for years in VBA, and you keep showing me all kinds of things I had no idea about. Excellent content taught in a very friendly manner.

[guss]

Excelente, saludos desde Salta Argentina

[mxrvxn]

Easy to follow and understand tutorial. Thank you

[redangrybird]

You are a Champ, thanks and God bless you.
✌😀

[BrianJones_cswp]

Thanks for making these videos, they've been extremely helpful to me! Clear, concise explanations in terms I can grasp, and the pace is spot on👍, subscribed.

[joaocustodio]

Well done Paul.
As always, very clear and didactic.

[grahamparker]

Really enjoyed this, gave a great overview 👌🏻

[clandeszipp]

Thank you.

Sometimes I wonder what is the gain in VBA speed all over the world (and economical gain for that matter) thanks to these lessons.

[dildokafir]

I must say dictionary part has won my heart. . Great trick. .thank for sharing it

[jlzpacheco]

AWESOME VIDEO! Perfect for finding yourself in this forest of knowledge!

[rrrprogram]

Nice video to refresh and revise ur understanding... Thanks paul

[ferkik.]

Thank you for your video. I'm using vba for a while but learnt a lot from your video to simplyfy my code. Currentregion is a very usefull code i didnt know that realy like it. Nowdays im working with data where there are blank rows what i cant delete. Do you have any tool how to handle this type of database?

[sebastiansalazar]

Very smart and simple. Now, for me is easy to filter thousands of data. Thank you very much indeed.

[vivekphadke]

Very useful for VBA novice like me, Thanks