Excel Macro Mastery
  • ubermenu logo50y
  • Member Area
      • Start here
          • How to use the Membership Area
          • The Blueprint for Learning Excel VBA
      • Downloads
          • 80+ Workbook Downloads
          • Cheat Sheets
      • Webinars
          • All Webinars

          • Most Popular
            • How to Design a VBA Application Like a Pro (Video)
            • 5 VBA Hacks Everyone Should know (Video)
            • How to use Class Modules in Excel VBA (Video)

          • Data Structures VBA
            • The Ultimate Guide to VBA Arrays (Video)
            • Excel VBA Collections – A Complete Guide (Video)
            • How to use the VBA Dictionary Like a Pro(Video)
          • Businesswoman pressing business type of modern buttons with virtHow to Copy Data Between ANY Two Sheets(Video)
      • Account Information
        • Subscription and Payment details
        • Lost your Password?

  • VBA Articles
  • Courses
  • Webinars
  • About
How to use the VBA Dictionary Like a Pro(Video)

How to use the VBA Dictionary Like a Pro(Video)

by Paul Kelly | | Data Structures VBA, Vault Video

Webinar Number: W0047 This webinar features: Live Coding – The only Excel VBA Webinar where code is written in real-time. A real-world example of using the Dictionary. What is the Dictionary and why do you need it? Why pros prefer the Dictionary to the...
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...
How to use the ArrayList in Excel VBA (Video)

How to use the ArrayList in Excel VBA (Video)

by Paul Kelly | | Data Structures VBA, Vault Video

Webinar Number: W0036 If you have used the Collection in VBA then you may have noticed that it is severely limited.  You cannot sort, check if an item exists write directly to a range and so on. What is there was an alternative to the Collection that had all these...
How To Use Arrays, Collections And Dictionaries (Video)

How To Use Arrays, Collections And Dictionaries (Video)

by Paul Kelly | | Data Structures VBA, Vault Video

Webinar Number: W0029 Arrays, Collections and Dictionaries are what we refer to as data structures. Many people are confused about the difference between them. What are the advantages and disadvantages of each data structure? How do you know which one to use in a...
How To Use Arrays, Collections And Dictionaries (Video)

When to use Arrays, Collections and Dictionaries (Video)

by Paul Kelly | | Data Structures VBA, Vault Video

Webinar Number: W0018 In this webinar, I cover using Arrays, Collections and Dictionaries. When should each be used? The pro and cons of each and a guide to selecting the correct one to use.   Downloads Download the workbook here.   Related Links VBA Arrays...
« 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

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok