Excel VBA Introduction Part 1 - Getting Started in the VB Editor Excel VBA Introduction Part 2 - Writing Your First VBA Macro Excel VBA Introduction Part 3 - What to do When Things Go Wrong (Errors and Debugging) Excel VBA Introduction Part 4 - Buttons, Toolbars and Keyboard Shortcuts Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) Excel VBA Introduction Part 6 - Worksheets, Charts and Sheets Excel VBA Introduction Part 7 - Workbooks Excel VBA Introduction Part 8 - Variables Excel VBA Introduction Part 9 - Object Variables Excel VBA Introduction Part 10 - Message Boxes Excel VBA Introduction Part 11.1 - Input Boxes Excel VBA Introduction Part 11.2 - Application.InputBox Excel VBA Introduction Part 12 - With Statements Excel VBA Introduction Part 13 - If Statements Excel VBA Introduction Part 14 - Select Case Statements Excel VBA Introduction Part 15 - Do Until and Do While Loops Excel VBA Introduction Part 15a - Find and FindNext Excel VBA Introduction Part 16 - For Next Loops Excel VBA Introduction Part 17 - For Each Loops Excel VBA Introduction Part 18 - Creating Functions Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo) Excel VBA Introduction Part 20.1 - Event Procedures Excel VBA Introduction Part 20.2 - Application Events Excel VBA Introduction Part 21 - User Forms Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects) Excel VBA Introduction Part 23 - Text Files (FileSystemObjects) Excel VBA Introduction Part 24 - File Dialogs Excel VBA Introduction Part 25 - Arrays Excel VBA Introduction Part 26 - Constants and Enumerations (Const, Enum) Excel VBA Introduction Part 27.1 - Creating Word Documents Excel VBA Introduction Part 27.2 - Creating and Updating Linked Word Tables Excel VBA Introduction Part 28.1 - Creating PowerPoint Presentations Excel VBA Introduction Part 29.1 - Creating Outlook Emails Excel VBA Introduction Part 29.2 - Outlook Email Events Excel VBA Introduction Part 29.3 - Outlook Emails using the Word Editor Excel VBA Introduction Part 29.4 - Inserting Pictures in Outlook Emails Excel VBA Introduction Part 29.5 - Copying Emails from the Outlook Inbox Excel VBA Introduction Part 29.6 - Referring to a Named Outlook Folder Excel VBA Introduction Part 29.7 - Looping Through all Outlook Folders Excel VBA Introduction Part 29.8 - Saving Attachments from an Outlook Folder Excel VBA Introduction Part 29.9 - Finding Outlook Emails using Filters Excel VBA Introduction Part 29.10 - Getting Emails from another Outlook Account Excel VBA Introduction Part 29.11 - Sending Emails from another Outlook Account Excel VBA Introduction Part 29.12 - Filtering Outlook Items using Restrict Excel VBA Introduction Part 29.13 - DASL Filters in Outlook Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database Excel VBA Introduction Part 31 - ADO (ActiveX Data Objects) Modifying Data with Recordsets Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE) Excel VBA Introduction Part 33 - Creating Add Ins Excel VBA Introduction Part 34 - Type Declarations (User-Defined Types) Excel VBA Introduction Part 35 - Class Modules Excel VBA Introduction Part 36 - Using Class Modules in Other Projects Excel VBA Introduction Part 37 - Custom Collections Excel VBA Introduction Part 38 - Typed Collections Excel VBA Introduction Part 39 - Dictionaries Excel VBA Introduction Part 40 - Disabling Screen Updates Excel VBA Introduction Part 41 - Saving as a PDF Excel VBA Introduction Part 43.1 - ByRef and ByVal Excel VBA Introduction Part 43.2 - ByRef and ByVal (When to use Parentheses) Excel VBA Introduction Part 44 - Making Excel Talk Excel VBA Introduction Part 45 - Finding the Last Used Row, Column and Cell Excel VBA Introduction Part 46 - Querying Web Pages using Query Tables Excel VBA Introduction Part 47.1 - Browsing to Websites and Scraping a Web Page Excel VBA Introduction Part 47.2 - Scraping Website Tables and Clicking Links Excel VBA Introduction Part 47.3 - Internet Explorer vs XML HTTP Request Excel VBA Introduction Part 47.4 - Logging in to a Website with Windows Security Excel VBA Introduction Part 47.5 - Basic HTTP GET and POST Requests Excel VBA Introduction Part 48 - Web Scraping Across Multiple Pages Excel VBA Introduction Part 49 - Downloading Files from Websites Excel VBA Introduction Part 50.1 - Introduction to Charts in VBA Excel VBA Introduction Part 50.2 - Embedding Charts in Worksheets Excel VBA Introduction Part 50.3 - Conditional Formatting by Value in Charts Excel VBA Introduction Part 50.4 - Highlighting Min and Max Values in a Chart Excel VBA Introduction Part 50.5 - Formatting Bubble Charts by Bubble Size Excel VBA Introduction Part 50.6 - Data Labels in Scatter Charts Excel VBA Introduction Part 51.1 - Introduction to Pivot Tables in VBA Excel VBA Introduction Part 51.2 - Pivot Tables using an Access Database Excel VBA Introduction Part 51.3 - Pivot Tables using a SQL Server Database Excel VBA Introduction Part 51.4 - Pivot Tables and Consolidation Ranges Excel VBA Introduction Part 51.5 - PowerPivot Data Models Excel VBA Introduction Part 51.6 - Pivot Charts Excel VBA Introduction Part 51.7 - Pivot Table Slicers Excel VBA Introduction Part 51.8 - Pivot Table Date Fields and Timelines Excel VBA Introduction Part 52.1 - Introduction to Shapes Excel VBA Introduction Part 52.2 - Formatting Shapes Excel VBA Introduction Part 52.3 - Adding Text to Shapes Excel VBA Introduction Part 53.1 - Working with Strings Excel VBA Introduction Part 53.2 - Splitting Strings Excel VBA Introduction Part 53.3 - The Join Function and Concatenating Strings Excel VBA Introduction Part 53.4 - Replacing Strings Excel VBA Introduction Part 53.5 - Converting the Case of Text Excel VBA Introduction Part 53.6 - The Asc and Chr Functions Excel VBA Introduction Part 54.1 - The IIf Function Excel VBA Introduction Part 54.2 - The Switch Function Excel VBA Introduction Part 55.1 - Working with Dates Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries Excel VBA Introduction Part 56.5 - Basic ADO Commands Excel VBA Introduction Part 56.6 - ADO Commands and Parameters Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome Excel VBA Introduction Part 57.2 - Basic Web Scraping with Selenium and Google Chrome Excel VBA Introduction Part 57.3 - Using Different Web Browsers with Selenium Excel VBA Introduction Part 57.4 - Finding Web Elements in Selenium Excel VBA Introduction Part 57.5 - Implicit and Explicit Waits in Selenium Excel VBA Introduction Part 57.6 - Working with Multiple Tabs in Selenium Excel VBA Introduction Part 57.7 - Using Select Drop Down Lists in Selenium Excel VBA Introduction Part 57.8 - Printing in Google Chrome using Selenium Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements Excel VBA Introduction Part 58.2 - SQL for Excel Files - Sorting Rows in a Query Excel VBA Introduction Part 58.3 - SQL for Excel Files - Selecting the Top N Rows Excel VBA Introduction Part 58.4 - SQL for Excel Files - Selecting All or Distinct Rows Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query Excel VBA Introduction Part 58.6 - SQL for Excel Files - Text Criteria and the Like Operator Excel VBA Introduction Part 58.7 - SQL for Excel Files - Basic Calculated Columns Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions Excel VBA Introduction Part 58.9 - SQL for Excel Files - Nulls in Expressions Excel VBA Introduction Part 58.10 - SQL for Excel Files - Date Expressions Excel VBA Introduction Part 58.11 - SQL for Excel Files - Text Expressions Excel VBA Introduction Part 58.12 - SQL for Excel Files - Aggregation Functions Excel VBA Introduction Part 58.13 - SQL for Excel Files - Grouping Rows Excel VBA Introduction Part 58.14 - SQL for Excel Files - Criteria in the Having Clause Excel VBA Introduction Part 58.15 - SQL for Excel Files - Pivoting Data Crosstab Queries Excel VBA Introduction Part 58.16 - SQL for Excel Files - Basic Union Queries Excel VBA Introduction Part 58.17 - SQL for Excel Files - Union Queries with Total Rows Excel VBA Introduction Part 58.18 - SQL for Excel Files - Union Queries from Multiple Files Excel VBA Introduction Part 58.19 - SQL for Excel Files - Inner Joins Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins Excel VBA Introduction Part 58.21 - SQL for Excel Files - Constructing Full Outer Joins Excel VBA Introduction Part 58.22 - SQL for Excel Files - Join Worksheets from Multiple Files Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side Excel VBA Introduction Part 58.24 - SQL for Excel Files - Consolidate Worksheets with Derived Tables Excel VBA Introduction Part 58.25 - SQL for Excel Files - Basic Subqueries Excel VBA Introduction Part 58.26 - SQL for Excel Files - Nested Subqueries Excel VBA Introduction Part 58.27 - SQL for Excel Files - Correlated Subqueries Excel VBA Introduction Part 58.28 - SQL for Excel Files - Inserting Data into an Existing Sheet Excel VBA Introduction Part 58.29 - SQL for Excel Files - Select Data into a New Sheet or Workbook Excel VBA Introduction Part 58.30 - SQL for Excel Files - Updating Existing Data Excel VBA Introduction Part 58.31 - SQL for Excel Files - Split a Table into Separate Sheets Wise Owl Answers - How do I list all properties of a file using VBA? Excel VBA Introduction Part 57.1 (Oct 2023) - Getting Started with Selenium Basic and Google Chrome Wise Owl Answers - How do I add Videos to PowerPoint Slides with VBA? Wise Owl Answers - How do I make a VBA event work in every workbook? Wise Owl Answers - How do I speed up calculations in Excel VBA?