Important notice to our attendees of
The Excel Data Analysis And Reporting Masterclass, April 18, 2017
Our masterclass had to relocate and will now be held at:
Room Mate Aitana Hotel
IJdok 6
1013 MM Amsterdam
Important notice to our attendees of
The Excel Data Analysis And Reporting Masterclass, April 18, 2017
Our masterclass had to relocate and will now be held at:
Room Mate Aitana Hotel
IJdok 6
1013 MM Amsterdam
We’ve just become famous, a nice post about our event has been published on the Microsoft MSDN blog
Register now, our early bird discount ends on Feb 20, 2017!
Alas, all good things come to an end and our Excel VBA Masterclass is no exception to that rule. We had two days crammed full with VBA information.
The atmosphere was vibrant and enthusiastic as our group selfies show:
and at the end of day one, most attendees even stayed longer in order to be able to spend extra time trying to solve one of our challenging assignments:
On top of all this, we received excellent feedback from our attendees. Read all about the event feedback here.
We’ve been working hard to build course content for Our Excel VBA Masterclass and in this mailing I’ll reveal the last bit of the course content (as outlined roughly here) so you can decide whether or not it is worthwile for you to attend.
Add-ins are a powerful addition to Excel. Creating add-ins isn’t hard to do, but there are many things to consider when you decide to deliver your code in an add-in. In this section of the course we will touch on these subjects:
We’ll talk about UDFs extensively and (amongst other things) demonstrate how code in a UDF can be optimised for speed.
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
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.
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.
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.
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
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.
A professionally designed VBA project cannot do without proper error handling. In this part of the course we will discuss:
Tune in next time when we discuss what our course will bring regarding Userforms.
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
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.
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
One part of this subject will involve writing a User Defined function demonstrating the effects of various code structures and methods on performance.
Tune in next time (well, I’ll send it to you 🙂 ) when we discuss what our course will bring regarding Error hendling techniques.
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
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.
We’ll start this subject by talking a bit about what Object Oriented Programming means and how this is implemented in VBA.
OOP in VBA uses class modules so we’ll dig into that some more.
We’ll distinguish class types by their function, touching on these three: Event classes, Object classes, and Classes of 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.
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.
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.
Tune in next time when we discuss what our course will bring regarding efficient coding.
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
You can now register for this training here.
Please note that by registering you accept our Event Conditions.
Hi everyone!
I’ve just sent out my newsletter with a nice report of our Summit
Enjoy the read.
Regards,
Jan Karel