Excel Macro Mastery
  • VBA Articles
  • Courses
  • Webinars
  • Account Information
How to Design a VBA Application Like a Pro (Video)

How to Design a VBA Application Like a Pro (Video)

by Paul Kelly | | Most Popular, Vault Video

Webinar Number: W0046 This webinar features: * Excel VBA Coding * How to structure your code – it’s not hard once you know the secret. * How to get notified immediately when an error occurs – this idea alone will save your hours of wasted time. *...
How to use Class Modules in Excel VBA (Video)

How to use Class Modules in Excel VBA (Video)

by Paul Kelly | | Classes and Objects, Most Popular, Vault Video

Webinar Number: W0041 This webinar includes: * Live Excel VBA Coding * What are Class Modules and why do I need them? * The 5 major advantages of using Class Modules that everyone should know. * How to use Class Modules with a Dictionary  – so easy you’ll...
The Ultimate Guide to VBA Arrays (Video)

The Ultimate Guide to VBA Arrays (Video)

by Paul Kelly | | Data Structures VBA, Most Popular, Vault Video

Webinar Number: W0038 Arrays have been an important part of programming languages for a long time. In Excel VBA they are even more important as they have many important uses. The most powerful being when it comes to speeding up your VBA code exponentially. This...
A complete guide to the VBA Dictionary (Video)

A complete guide to the VBA Dictionary (Video)

by Paul Kelly | | Data Structures VBA, Most Popular, Vault Video

Webinar Number: W0037 It’s the start of a brand new year. And what better way to kick it off than with a live webinar on one of the most useful elements in VBA – The Excel VBA Dictionary. This webinar features: * The only VBA Webinar with Live Coding. * A...
Excel VBA Cells and Ranges – A Complete Guide (Video)

Excel VBA Cells and Ranges – A Complete Guide (Video)

by Paul Kelly | | Excel Specific, Most Popular, Vault Video

Webinar Number: W0030 Everybody has heard of Pareto’s 80/20 rule. 80% of your work comes from 20% of your efforts. In Excel VBA, 80 to 90% of your work will involve using Cells and Ranges. If you can master using this area of VBA then everything else you do will...
VBA AutoFilter – Copying Data at Super Speed (Video)

VBA AutoFilter – Copying Data at Super Speed (Video)

by Paul Kelly | | Copying Data, Most Popular, Vault Video

Webinar Number: W0027 This webinar features: Live coding Why you shouldn’t use a For Loop How to use Advanced filter correctly The common mistakes to avoid when using Advanced Filter A sample application using Advanced Filter functionality Proven principles used...
« Older Entries

You are not logged in

You are not currently logged in.








» Register
» Lost your Password?
  • Facebook
  • Twitter
  • Instagram
  • RSS

Designed by Elegant Themes | Powered by WordPress