Excel VBA Editor Mastery!
4.5 (68 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,920 students enrolled

Excel VBA Editor Mastery!

Learn VBA fundamentals and the editor tools which will save hours of your time!
4.5 (68 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,920 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn how to understand, navigate, and use the VBA editor
  • Learn how to debug quickly and effectively
  • Learn basic VBA and programming concepts
Requirements
  • None!
Description

I have made this content as a standalone course to serve all Excel users!

Please be aware however, that you will already have this content if you're enrolled on either of these other two courses:

"Excel VBA for Financial Modeling | Excel Automation"
"VBA for Project Finance Models | Circular Debt Calculations"

--------------------

Prepare to save yourself time... LOTS of it!


That's why people come to use VBA after all... to save time!

The irony is though... that most people know so little about VBA and coding that they end up *wasting* TONS as they quest to save it!!

I was in the exact situation for MANY years... but now I know better... I cannot *believe* how much time I lost to poor and inefficient work practices!!

I don't want YOU to have this same experience, so I've put together all that I've learned about the VBA editor so that you can learn how to harness it PROPERLY.

This knowledge will enable you to save time WHILE you code! (Not just when you run your code...)

You'll learn lots of tips, tricks, and secrets a majority of VBA users have absolutely no clue about!

These will revolutionise the way you work with VBA and how you work with its associated programmes - not least Excel!

You'll be amazed to discover how much power you'll have your hands!!!!

Who this course is for:
  • All Excel users interested or already working with VBA
Course content
Expand 10 lectures 01:13:21
+ Mastering the VBA Editor
10 lectures 01:13:21

What is VBA and why bother learning it? And who am I to be teaching it!?

Preview 05:18

Learn about the different text events recognised by the VBA editor and how you can customise the look of the editor to highlight all these different elements to improve your understanding and clarity of your VBA code!

Preview 12:03

Explore the main coding window, and script your first programme - or "procedure" - following a time-honoured approach...

The Main Code Window
10:47

Learn about the editor's modes, when you need them and how to switch between them.

VBA editor modes
06:02

Discover the tool you'll rely on the most when working on your code and learn how it can help your debugging!

The immediate window
04:49

Dig deeper into your code and learn to monitor the state of all the variables you are using. You'll also learn how to do this when you are working with multiple, nested procedure calls!

Locals and call stack windows
09:02

Give those bugs no place to hide! The watch window gives you fully customisable scrutiny of your procedure and allows you to automate editor responses. This will seriously level up your debugging game!

Watch window
10:22

Explore the back-end of your VBA project and learn how to manipulate key properties using the editor's graphical interface.

Project & property windows
06:59

10 top tips to turn you into a power VBA wielder who works faster, smarter and a lower your error rate than your peers!

10 Top Tips for using the VBA editor!
06:51

Don't forget to take this cheat sheet with you! It has all you need...!!

VBA Cheat Sheet & BONUS LECTURE
01:08