The Excel VBA Masterclass, what to expect part 4

The Excel VBA Masterclass, what to expect part 4


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 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.


Many VBA developers will have started their career with Excel’s macro recorder. Soon after they start to edit recorded macro’s and then discover at some point they need to get information from the user. If this information is more than a simple yes/No or a single choice, or if a specific UI design is needed the most efficient way in VBA is to build a Userform.


We’ll discuss why design of a form is important and what you might consider doing (and not doing)


Anything your form needs to do has to be programmed, this is where Events come in. We’ll talk about them extensively.

Run-time vs design-time addition of controls

If you know up front what fields are needed for your form, you can manually draw them on the designer canvas. But what if there are many controls or if you don’t know up front how many there are? We’ll show you how to handle both processes efficiently.

Treating them as a class

Out of the box, Excel VBA allows you to address a userfrom by its classname directly. We’ll discuss why there are better ways of doing this.

Up next: Add-ins

Tune in next time when we discuss what our course will bring regarding Add-ins.


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

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.