Channel Title: Excel Macro Mastery Channel Description: Welcome to my Excel VBA Channel. My name is Paul Kelly(Microsoft MVP) and I'm here to teach you how to write Excel VBA for the real world. This channel will teach you proven techniques and little-known secrets about Excel VBA. These are techniques and secrets that I have used myself for over 20 years as a professional software developer. In these videos, I break down complex Excel VBA topics in simple terms. I explain each part with code examples. Then I show you how to put it all together with real-world coding examples. You can check out free articles on my Excel VBA website: https://excelmacromastery.com/vba-articles/ Become an Excel VBA Mastery: ☛ The Excel VBA Handbook course: https://courses.excelmacromastery.com/courses/excel-vba-handbook ☛ Effective Excel VBA: https://courses.excelmacromastery.com/courses/Effective_Excel_VBA ☛ The Webinars Archives Membership: https://excelmacromastery.com/live-webinars/ <video> Python for VBA Developers in 30 Minutes Description: 👉 Ready to Master VBA? - Check out my course: https://bit.ly/3XTnIm8 - Subscribe to the channel here: https://bit.ly/36hpTCY Python for VBA Developers in 30 Minutes Are you an Excel VBA user looking to expand your skills and harness the power of Python? This tutorial is designed just for you! 🚀 In "The Ultimate Python Tutorial for VBA Users," I’ll guide you step-by-step through the basics of Python, comparing it to VBA concepts you already know. Learn how Python can simplify your workflow, handle complex data tasks, and integrate seamlessly with Excel. What you’ll discover in this video: ✅ Key differences and similarities between Python and VBA ✅ How to set up Python for Excel automation ✅ Writing your first Python script as a VBA developer ✅ Tips and tools for transitioning smoothly to Python Whether you’re a seasoned VBA expert or just starting out, this tutorial will open the door to new possibilities and make your coding life easier! 💻🔧 #VBAPython #ExcelPython #ExcelOpenPyxl #ExcelPandas Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard) </video> <video> How I Made 2 VBA Applications Run Ultrafast Description: 👉 Ready to master VBA? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY How I Made 2 VBA Applications Run Ultrafast In this video, I take two extremely slow Excel VBA applications and I make them run in under a second. First of all, I will show you how long they take to run and then I will show you the steps to make them increase their speed exponentially. If your VBA applications are running slowly then this video is for you. #ExcelVBA #VBASlowCode #VBACodeFast Dictionary Playlist: https://www.youtube.com/playlist?list=PL7ScsebMq5uUgeV-r9gIAAvXtgIxURfHa Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> VBA Unleashed: Send Customized Emails in One Line Description: 👉 Ready to master VBA? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY -Want to download the source code for this video? Go here: https://rb.gy/xkv38 (Note: If the download page doesn't work then make sure to turn off any popup blockers) VBA Unleashed: Send Customized Emails in One Line In this video, we're going to show you how to send fully customizable emails from VBA (Visual Basic for Applications) with just one line of code. If you're tired of spending hours configuring VBA email code for each scenario, then this tutorial is for you. First I cover how to create and configure emails in Excel VBA and then I show you how to do it all in one simple line of code. #ExcelVBA #VBASendEmail #VBAOutlook Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> Can This Code Be Saved? | VBA Code Audit Description: 👉 Ready to become a VBA Expert? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY Can This Code Be Saved? | VBA Code Audit In this video I review the code submitted by my customers. Watch this video if you want to improve your own code. This video is packed with tips and techniques for writing clean and efficient code. #ExcelVBA #VBACodeReview #VBACodeAudit Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> VBA Run-Time Error '9' Subscript out of range - How to Fix it Description: 👉 Ready to Master VBA? - Check out my course: https://bit.ly/3XTnIm8 - Subscribe to the channel here: https://bit.ly/36hpTCY VBA Run-Time Error '9' Subscript out of range - How to Fix it In this video, we'll help you troubleshoot and resolve the common VBA error: "Run-Time Error '9' Subscript out of Range." You'll learn the key causes of this error, such as incorrect sheet names, referencing non-existent arrays, and other common coding mistakes. We'll walk you through practical examples and show you how to quickly identify and fix these issues, ensuring smoother VBA code execution. Whether you're a beginner or an advanced user, this guide will help you prevent future subscript errors in your VBA projects! 💻🔧 #VBAListBox #ExcelVBAListbox #VBAUserFormListbox #ModernVBAListbox Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard) </video> <video> Modern Excel VBA Listbox Preview Description: 👉 Ready to Master VBA? - Check out my course: https://bit.ly/3XTnIm8 - Subscribe to the channel here: https://bit.ly/36hpTCY "Modern VBA Listbox Preview" This video covers the new Modern VBA Listbox which I am working on. It has tons of useful features like sorting, filtering, single or multi-selection with select and deselect all, page navigation and hover highlight, 💻🔧 #VBAListBox #ExcelVBAListbox #VBAUserFormListbox #ModernVBAListbox Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard) Table of Contents: 00:00 - Introduction 00:22 - Why You Need Arrays 10:17 - How to Replace Ranges with Arrays 21:19 - Using Arrays in a real-world example 27:18 - Important - Avoid this major pitfall 31:59 - The code structure for all data manipulation 40:04 - How to easily sort any Array with this new method </video> <video> I Made this VBA Code 2,880,952% faster Description: Want to improve your Excel VBA skills fast? Go here: ▸https://courses.excelmacromastery.com/ Want to download the source code for this video? Go here: https://shorturl.at/ltxLZ Subscribe to the channel here: https://bit.ly/36hpTCY I Made this VBA Code 2,880,952% faster A user recently sent me Excel VBA code that was taking 6 hours to run and asked if I could somehow improve the speed. In this video I show how I made this code run in mere milliseconds with a few changes. If you want to avoid having slow VBA code in the future then this video is a must watch. 💻🔧 #VBA #VBAFast #VBASpeed Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> 25 Nooby VBA Habits You Need to Ditch Right Now Description: Want to improve your Excel VBA skills fast? Go here: ▸https://courses.excelmacromastery.com/ Subscribe to the channel here: https://bit.ly/36hpTCY 25 Nooby VBA Habits You Need to Ditch Right Now Unlock the full potential of your VBA skills by breaking free from these 25 common nooby habits! 🚀 In this video , we look at the Excel VBA habits that may be holding you back and show you what to do instead. Whether you're a beginner or an experienced user, ditching these habits will boost your productivity and make you a VBA pro in no time. From inefficient coding practices to overlooked shortcuts, we've got you covered. Don't let these habits hinder your VBA journey – watch now and level up your programming game! 💻🔧 #VBA #ProgrammingHabits #CodeLikeAPro Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> How to Master VBA loops FAST (with real coding examples) Description: Learn how to write real-world Excel VBA code: 👉https://courses.excelmacromastery.com/ Subscribe to the channel here: https://bit.ly/36hpTCY How to Master VBA loops FAST (with real coding examples) VBA has 4 types of loops and one of these loops can be written in 4 ways. This leads to a lot of confusion. In this video I am going to show you exactly what each loop is for and when to use it and which loops you can avoid #ExcelVBALoops #VBADoUntil #VBADoWhile Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Repeat last search: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> The 3 Critical Data Scenarios Every VBA User Should Know Description: 👉 Ready to Master VBA? - Check out my course: https://bit.ly/3XTnIm8 - Subscribe to the channel here: https://bit.ly/36hpTCY - Want to download the cheat sheet for this video? Go here: https://shorturl.at/qEjZS (Note: If the download page doesn't work then make sure to turn off any popup blockers) "The 3 Critical Data Scenarios Every VBA User Should Know" This video is designed for Excel users looking to enhance their VBA (Visual Basic for Applications) skills. The video covers three essential data handling scenarios that are pivotal for effective automation and data manipulation. Viewers will learn practical techniques to streamline their workflows, tackle common data challenges, and unlock the full potential of VBA in their Excel projects. Perfect for both beginners and seasoned users, this tutorial offers valuable tips and actionable advice for mastering data management with VBA. 💻🔧 #VBAData #ExcelVBAData #VBADataManipulation Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard) Table of Contents: 00:00 - Introduction 00:22 - Why You Need Arrays 10:17 - How to Replace Ranges with Arrays 21:19 - Using Arrays in a real-world example 27:18 - Important - Avoid this major pitfall 31:59 - The code structure for all data manipulation 40:04 - How to easily sort any Array with this new method </video> <video> 10 Years of VBA Array Knowledge in 40 Mins Description: 👉 Ready to Master VBA? - Check out my course: https://bit.ly/3XTnIm8 - Subscribe to the channel here: https://bit.ly/36hpTCY - Want to download the source code for this video? Go here: https://shorturl.at/nMnc6 (Note: If the download page doesn't work then make sure to turn off any popup blockers) "10 Years of VBA Array Knowledge in 40 Mins" Arrays are possibly the most important element of Excel VBA. Not only do arrays make your code more readable, they also allow you to process data thousands of times faster than using Ranges. If you haven't used arrays before then you may be intimidated by them. But don't worry - In this video, I will distil years of VBA knowledge and experience into a set of simple steps that anyone can follow. 💻🔧 #VBAArray #VBAArrays #ExcelVBAArrays Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard) Table of Contents: 00:00 - Introduction 00:22 - Why You Need Arrays 10:17 - How to Replace Ranges with Arrays 21:19 - Using Arrays in a real-world example 27:18 - Important - Avoid this major pitfall 31:59 - The code structure for all data manipulation 40:04 - How to easily sort any Array with this new method </video> <video> How to Create a UserForm Like a Pro Description: Want to improve your Excel VBA skills fast? Go here: ▸https://courses.excelmacromastery.com/ Want to download the source code for this video? Go here: https://shorturl.at/yBSVX Subscribe to the channel here: https://bit.ly/36hpTCY How to Create a UserForm Like a Pro Creating UserForms in VBA should not be that complicated. However, there are lots of pitfalls for the unwary. For example 1. How do you retrieve a value after the userForm closes? 2. How do you avoid automation errors if the error cancels using X? 3. How do you stop a modeless UserForm from disappearing? 4. How do you pass the initial settings to the UserForm before the initialize event runs? ...and so on. In this video, I show how to create a Modal and Modeless UserForm and how to avoid the issues that arise when you use them. 💻🔧 #VBA #VBAUserForm #UserForm #ExcelVBAUser #modal Learn how to build Excel VBA Applications the right way using best practices and proven techniques The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com) Free Excel VBA Resources Excel VBA Articles (https://excelmacromastery.com/vba-articles/) Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> I Built a Modern Listbox UI for Excel VBA Description: 👉 Ready to Master VBA? - Check out my course: https://bit.ly/3XTnIm8 - Subscribe to the channel here: https://bit.ly/36hpTCY - Download the Modern Listbox here: https://shorturl.at/li0yO I Built a Modern Listbox UI for Excel VBA This video covers the new Modern VBA Listbox. It has tons of useful features like sorting, filtering, single or multi-selection with select and deselect all, page navigation and hover highlight, 💻🔧 #VBAListBox #ExcelVBAListbox #VBAUserFormListbox #ModernVBAListbox Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard) </video> <video> How to Customize Controls in Excel VBA Description: 👉 Ready to become a VBA Expert? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY -Want to download the source code for this video? Go here: https://shorturl.at/gieQs (Note: If the download page doesn't work then make sure to turn off any popup blockers) How to Customize Controls in Excel VBA In this video I cover how to use "With Events". This allows use to customize the behaviour of UserForm controls. This means we can create custom controls like a searchable dropdown. #VBACustomevents #withEvents Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video> <video> How to Use Nested Dictionaries in VBA Description: 👉 Ready to master VBA? - Check out my full courses: https://courses.excelmacromastery.com/ - Subscribe to the channel here: https://bit.ly/36hpTCY -Want to download the source code for this video? Go here: https://shorturl.at/qCFIP (Note: If the download page doesn't work then make sure to turn off any popup blockers) How to Use Nested Dictionaries in VBA #ExcelVBALoops #VBADoUntil #VBADoWhile Mentioned in the video: Using Web APIs video: https://youtu.be/KZeYKZJzQIk?si=G5mSmUeGIzkie50s Dictionary Playlist: https://www.youtube.com/playlist?list=PL7ScsebMq5uUgeV-r9gIAAvXtgIxURfHa Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9(or click left margin) Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Auto complete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *) To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y(note: this clears the clipboard) </video>

Contacts and Links

Description

Welcome to my Excel VBA Channel. My name is Paul Kelly(Microsoft MVP) and I'm here to teach you how to write Excel VBA for the real world.

This channel will teach you proven techniques and little-known secrets about Excel VBA. These are techniques and secrets that I have used myself for over 20 years as a professional software developer.

In these videos, I break down complex Excel VBA topics in simple terms. I explain each part with code examples. Then I show you how to put it all together with real-world coding examples.

You can check out free articles on my Excel VBA website: https://excelmacromastery.com/vba-articles/

Become an Excel VBA Mastery:
☛ The Excel VBA Handbook course: https://courses.excelmacromastery.com/courses/excel-vba-handbook
☛ Effective Excel VBA: https://courses.excelmacromastery.com/courses/Effective_Excel_VBA
☛ The Webinars Archives Membership: https://excelmacromastery.com/live-webinars/

Videos from channel