The Excel VBA Masterclass, what to expect part 2

Why should you register?

We’ve been working hard to build course content for Our Excel VBA Masterclass and in this second post I’ll reveal a bit more about the course content (as outlined roughly here) so you can decide whether or not it is worthwile for you to attend.

Efficient coding

As a potential attendee of this course you will have acquired quite some knowledge on how to code in VBA. But are you aware of the intricacies of VBA and Excel when it comes to writing code that has good performance? In this session we’ll discuss things like:•How to measure performance

• Efficiently exchanging information with Excel
• How to optimise for speed
• Structuring code for speed

One part of this subject will involve writing a User Defined function demonstrating the effects of various code structures and methods on performance.

Up next: Error handling

Tune in next time (well, I’ll send it to you 🙂 ) when we discuss what our course will bring regarding Error hendling techniques.

Registration

Our Excel VBA Masterclass training covering advanced VBA subjects such as Error handling, Userform design, Class modules and etcetera is open for registration.
Training dates: October 26 and 27, 2016
Location: Zilveren Toren, Amsterdam

The Excel VBA Masterclass, what to expect part 1

Why should you register?

We’ve been working hard to build course content for Our Excel VBA Masterclass and in this post I’ll reveal the first bit of the course content (as outlined roughly here) so you can decide whether or not it is worthwile for you to attend.

Discussing OOP and Class modules

We’ll start this subject by talking a bit about what Object Oriented Programming means and how this is implemented in VBA.

Classes

OOP in VBA uses class modules so we’ll dig into that some more.

Types of classes

We’ll distinguish class types by their function, touching on these three: Event classes, Object classes, and Classes of classes.

Event Classes

An event class is a class that is mainly created to handle events. Any VBA programmer will sooner or later get acquainted with the worksheet modules and the ThisWorkbook modules and use them to have VBA code respond to events in the workbook or worksheet in question. Note that these events are “local” in such a sense that the only events you can respond to are events in the workbook your VBA code is a part of. But in some situations you need to trigger code when something happens at a higher level, for example when a workbook is opened or closed in Excel. The only way to respond to such events is by writing a class module.

Object classes

Classes are not just for handling events. In fact, handling events is just a tiny part of what classes can do for you. In this chapter I will demonstrate a class which enables you unprotect a worksheet in a workbook and which automatically protects it when your code ends.

Classes of Classes

A situation which regularly arises is one where you have the collection-item combination. For example, a workbook has a collection of worksheets. In this part of the course we demonstrate how you set up the necessary plumbing to make this work reliably.

Up next: Efficient coding

Tune in next time when we discuss what our course will bring regarding efficient coding.

Registration

Our Excel VBA Masterclass training covering advanced VBA subjects such as Error handling, Userform design, Class modules and etcetera is open for registration.
Training dates: October 26 and 27, 2016
Location: Zilveren Toren, Amsterdam

Registration for our Excel VBA Masterclass is now open!

You can now register for this training here.
Please note that by registering you accept our Event Conditions.