
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!
Explore the main coding window, and script your first programme - or "procedure" - following a time-honoured approach...
Learn about the editor's modes, when you need them and how to switch between them.
Discover the tool you'll rely on the most when working on your code and learn how it can help your debugging!
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!
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!
Explore the back-end of your VBA project and learn how to manipulate key properties using the editor's graphical interface.
10 top tips to turn you into a power VBA wielder who works faster, smarter and a lower your error rate than your peers!
THIS COURSE WILL CHANGE EVERYTHING...!!!
Yes, of course I'd say that.... but this time it's true!
How many times have you...
Had to clean up your financial model to share with clients?
Had to reconfigure Excel display settings because they got messed up?
Lost sleep because you didn't keep your financial model's log up to date?
Had to repeatedly go through the financial model to manually remove sensitive information?
Wasted time keeping track of all the defined names in your model?
Had to lose time manually saving files for every case and scenario you calculate?
How would you feel... if all you had to do... was press a magic button and BOOM!
You finish in less than 1 second???
And what would it be worth to YOU, to know how to build your own Excel automation routines to take over the repetitive grunt work you always knew was a job for machines to do???
Learning VBA can give you ALL OF THIS!
This course teaches VBA to automate Excel by guiding you through SEVEN automation tools built for financial modelers!
You won't be left scratching your head wondering what all the VBA's for because you will be using it straight away to discover how to save yourself time at work!
I simply can't imagine a world without VBA now... I mean how would you feel if they took away your keyboard??? ... the INTERNET?????!!!
Once you know the secrets of VBA, you will never look back and frankly, the way you use Excel will never be the same again...
New doors will open - and you will be flying through them!