The Excel VBA Masterclass, what to expect part 5

Why should you register?

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

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:

• When to use an add-in
  as opposed to a “normal” workbook
• How to develop add-ins
  Things to consider when you’re writing code for an add-in
• Automating installation
  As simple as it may seem to you, many users have a hard time installing add-ins. Here’s how to help them (and make sure your add-in gets used)
• Updating Add Ins
  Having one version of the truth is very important. Given that many people use laptops you may want your add-in to be available off-line too. This means a local copy of your add-in will reside on their C-drive. How can you ensure these copies stay up to date?
• Manual update using central location
  Sometimes all users are connected to the network shares all the time, how can you make sure you can update an add-in used by many people?
• Programmatically updating an add-in
  Doing it all automagically!

User-defined functions

We’ll talk about UDFs extensively and (amongst other things) demonstrate how code in a UDF can be optimised for speed.

Registration

Our Excel VBA Masterclass training covering advanced VBA subjects such as Error handling, Userform design, Class modules and etcetera will open for registration soon.
Training dates: End of 2018 or start of 2019
Location: To be determined.