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 Master the VBA Dictionary

How to Master the VBA Dictionary

by Paul Kelly | | Building Applications, Vault Video

Webinar Number: W0056 This webinar features: Real-world code examples. What is the Dictionary and why do you need it? Practical uses of the dictionary. How to write the Dictionary keys and items to a Range without a loop How to easily fix any issue with the Dictionary...
7 Steps to Building VBA Applications

7 Steps to Building VBA Applications

by Paul Kelly | | Building Applications, Vault Video

Webinar Number: W0055 This webinar features: Learn a system for building Excel VBA applications. How anyone can get started creating an Excel VBA application How to easily design your application without the need for complex tools or methods A technique for testing...
How to Copy Data Between ANY Two Sheets(Video)

How to Copy Data Between ANY Two Sheets(Video)

by Paul Kelly | | Copying Data, Vault Video

Webinar Number: W0050 This webinar features: Live Excel VBA Coding A simple guide that will help you select the correct worksheet every time How to decide which workbook should contain the code How to copy data on the same worksheet How to copy to or from a closed...
5 Simple Methods for Writing Clean VBA Code(Video)

5 Simple Methods for Writing Clean VBA Code(Video)

by Paul Kelly | | Building Applications, Intermediate VBA, Vault Video

Webinar Number: W0049 This webinar features: Live Excel VBA Coding What is clean code? The 3 major advantages of writing clean code. 5 ways to make your code clean – it’s not hard once you know the secret. A simple method that will make your code ten times...
7 Steps to Building Professional Quality VBA Applications(Video)

7 Steps to Building Professional Quality VBA Applications(Video)

by Paul Kelly | | Building Applications, Vault Video

Webinar Number: W0048 This webinar features: How anyone can get started creating an Excel VBA application How to easily design your application without the need for complex tools or methods A technique for testing your output so you are 100% sure your code is doing...
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...
« 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