VBA & Macros — Complete Excel VBA Guide

540 articles — click any topic for a detailed guide with solutions, examples, and expert tips.

• Getting Started with VBA
• Getting Started with VBA — Step-by-Step Tutorial
• Getting Started with VBA — Code Examples
• Getting Started with VBA — Common Errors & Fixes
• Getting Started with VBA — Best Practices
• Getting Started with VBA — Advanced Techniques
• VBA Editor Overview
• VBA Editor Overview — Step-by-Step Tutorial
• VBA Editor Overview — Code Examples
• VBA Editor Overview — Common Errors & Fixes
• VBA Editor Overview — Best Practices
• VBA Editor Overview — Advanced Techniques
• Recording Macros
• Recording Macros — Step-by-Step Tutorial
• Recording Macros — Code Examples
• Recording Macros — Common Errors & Fixes
• Recording Macros — Best Practices
• Recording Macros — Advanced Techniques
• Writing Your First Macro
• Writing Your First Macro — Step-by-Step Tutorial
• Writing Your First Macro — Code Examples
• Writing Your First Macro — Common Errors & Fixes
• Writing Your First Macro — Best Practices
• Writing Your First Macro — Advanced Techniques
• Variables and Data Types
• Variables and Data Types — Step-by-Step Tutorial
• Variables and Data Types — Code Examples
• Variables and Data Types — Common Errors & Fixes
• Variables and Data Types — Best Practices
• Variables and Data Types — Advanced Techniques
• If Then Else Statements
• If Then Else Statements — Step-by-Step Tutorial
• If Then Else Statements — Code Examples
• If Then Else Statements — Common Errors & Fixes
• If Then Else Statements — Best Practices
• If Then Else Statements — Advanced Techniques
• For Next Loop
• For Next Loop — Step-by-Step Tutorial
• For Next Loop — Code Examples
• For Next Loop — Common Errors & Fixes
• For Next Loop — Best Practices
• For Next Loop — Advanced Techniques
• For Each Loop
• For Each Loop — Step-by-Step Tutorial
• For Each Loop — Code Examples
• For Each Loop — Common Errors & Fixes
• For Each Loop — Best Practices
• For Each Loop — Advanced Techniques
• Do While Loop
• Do While Loop — Step-by-Step Tutorial
• Do While Loop — Code Examples
• Do While Loop — Common Errors & Fixes
• Do While Loop — Best Practices
• Do While Loop — Advanced Techniques
• Do Until Loop
• Do Until Loop — Step-by-Step Tutorial
• Do Until Loop — Code Examples
• Do Until Loop — Common Errors & Fixes
• Do Until Loop — Best Practices
• Do Until Loop — Advanced Techniques
• Select Case Statement
• Select Case Statement — Step-by-Step Tutorial
• Select Case Statement — Code Examples
• Select Case Statement — Common Errors & Fixes
• Select Case Statement — Best Practices
• Select Case Statement — Advanced Techniques
• Arrays in VBA
• Arrays in VBA — Step-by-Step Tutorial
• Arrays in VBA — Code Examples
• Arrays in VBA — Common Errors & Fixes
• Arrays in VBA — Best Practices
• Arrays in VBA — Advanced Techniques
• Working with Ranges
• Working with Ranges — Step-by-Step Tutorial
• Working with Ranges — Code Examples
• Working with Ranges — Common Errors & Fixes
• Working with Ranges — Best Practices
• Working with Ranges — Advanced Techniques
• Working with Worksheets
• Working with Worksheets — Step-by-Step Tutorial
• Working with Worksheets — Code Examples
• Working with Worksheets — Common Errors & Fixes
• Working with Worksheets — Best Practices
• Working with Worksheets — Advanced Techniques
• Working with Workbooks
• Working with Workbooks — Step-by-Step Tutorial
• Working with Workbooks — Code Examples
• Working with Workbooks — Common Errors & Fixes
• Working with Workbooks — Best Practices
• Working with Workbooks — Advanced Techniques
• String Functions
• String Functions — Step-by-Step Tutorial
• String Functions — Code Examples
• String Functions — Common Errors & Fixes
• String Functions — Best Practices
• String Functions — Advanced Techniques
• Date Functions
• Date Functions — Step-by-Step Tutorial
• Date Functions — Code Examples
• Date Functions — Common Errors & Fixes
• Date Functions — Best Practices
• Date Functions — Advanced Techniques
• Math Functions
• Math Functions — Step-by-Step Tutorial
• Math Functions — Code Examples
• Math Functions — Common Errors & Fixes
• Math Functions — Best Practices
• Math Functions — Advanced Techniques
• Error Handling
• Error Handling — Step-by-Step Tutorial
• Error Handling — Code Examples
• Error Handling — Common Errors & Fixes
• Error Handling — Best Practices
• Error Handling — Advanced Techniques
• On Error Resume Next
• On Error Resume Next — Step-by-Step Tutorial
• On Error Resume Next — Code Examples
• On Error Resume Next — Common Errors & Fixes
• On Error Resume Next — Best Practices
• On Error Resume Next — Advanced Techniques
• On Error GoTo
• On Error GoTo — Step-by-Step Tutorial
• On Error GoTo — Code Examples
• On Error GoTo — Common Errors & Fixes
• On Error GoTo — Best Practices
• On Error GoTo — Advanced Techniques
• Custom Error Handlers
• Custom Error Handlers — Step-by-Step Tutorial
• Custom Error Handlers — Code Examples
• Custom Error Handlers — Common Errors & Fixes
• Custom Error Handlers — Best Practices
• Custom Error Handlers — Advanced Techniques
• UserForms
• UserForms — Step-by-Step Tutorial
• UserForms — Code Examples
• UserForms — Common Errors & Fixes
• UserForms — Best Practices
• UserForms — Advanced Techniques
• InputBox
• InputBox — Step-by-Step Tutorial
• InputBox — Code Examples
• InputBox — Common Errors & Fixes
• InputBox — Best Practices
• InputBox — Advanced Techniques
• MsgBox
• MsgBox — Step-by-Step Tutorial
• MsgBox — Code Examples
• MsgBox — Common Errors & Fixes
• MsgBox — Best Practices
• MsgBox — Advanced Techniques
• ListBox
• ListBox — Step-by-Step Tutorial
• ListBox — Code Examples
• ListBox — Common Errors & Fixes
• ListBox — Best Practices
• ListBox — Advanced Techniques
• ComboBox
• ComboBox — Step-by-Step Tutorial
• ComboBox — Code Examples
• ComboBox — Common Errors & Fixes
• ComboBox — Best Practices
• ComboBox — Advanced Techniques
• TextBox Controls
• TextBox Controls — Step-by-Step Tutorial
• TextBox Controls — Code Examples
• TextBox Controls — Common Errors & Fixes
• TextBox Controls — Best Practices
• TextBox Controls — Advanced Techniques
• Command Buttons
• Command Buttons — Step-by-Step Tutorial
• Command Buttons — Code Examples
• Command Buttons — Common Errors & Fixes
• Command Buttons — Best Practices
• Command Buttons — Advanced Techniques
• Check Boxes
• Check Boxes — Step-by-Step Tutorial
• Check Boxes — Code Examples
• Check Boxes — Common Errors & Fixes
• Check Boxes — Best Practices
• Check Boxes — Advanced Techniques
• Option Buttons
• Option Buttons — Step-by-Step Tutorial
• Option Buttons — Code Examples
• Option Buttons — Common Errors & Fixes
• Option Buttons — Best Practices
• Option Buttons — Advanced Techniques
• Frames
• Frames — Step-by-Step Tutorial
• Frames — Code Examples
• Frames — Common Errors & Fixes
• Frames — Best Practices
• Frames — Advanced Techniques
• Working with Files
• Working with Files — Step-by-Step Tutorial
• Working with Files — Code Examples
• Working with Files — Common Errors & Fixes
• Working with Files — Best Practices
• Working with Files — Advanced Techniques
• Opening Files
• Opening Files — Step-by-Step Tutorial
• Opening Files — Code Examples
• Opening Files — Common Errors & Fixes
• Opening Files — Best Practices
• Opening Files — Advanced Techniques
• Saving Files
• Saving Files — Step-by-Step Tutorial
• Saving Files — Code Examples
• Saving Files — Common Errors & Fixes
• Saving Files — Best Practices
• Saving Files — Advanced Techniques
• File Dialog
• File Dialog — Step-by-Step Tutorial
• File Dialog — Code Examples
• File Dialog — Common Errors & Fixes
• File Dialog — Best Practices
• File Dialog — Advanced Techniques
• Copying Data Between Workbooks
• Copying Data Between Workbooks — Step-by-Step Tutorial
• Copying Data Between Workbooks — Code Examples
• Copying Data Between Workbooks — Common Errors & Fixes
• Copying Data Between Workbooks — Best Practices
• Copying Data Between Workbooks — Advanced Techniques
• Automating Email from Excel
• Automating Email from Excel — Step-by-Step Tutorial
• Automating Email from Excel — Code Examples
• Automating Email from Excel — Common Errors & Fixes
• Automating Email from Excel — Best Practices
• Automating Email from Excel — Advanced Techniques
• Working with Charts
• Working with Charts — Step-by-Step Tutorial
• Working with Charts — Code Examples
• Working with Charts — Common Errors & Fixes
• Working with Charts — Best Practices
• Working with Charts — Advanced Techniques
• Formatting Cells
• Formatting Cells — Step-by-Step Tutorial
• Formatting Cells — Code Examples
• Formatting Cells — Common Errors & Fixes
• Formatting Cells — Best Practices
• Formatting Cells — Advanced Techniques
• Conditional Formatting via VBA
• Conditional Formatting via VBA — Step-by-Step Tutorial
• Conditional Formatting via VBA — Code Examples
• Conditional Formatting via VBA — Common Errors & Fixes
• Conditional Formatting via VBA — Best Practices
• Conditional Formatting via VBA — Advanced Techniques
• Pivot Tables via VBA
• Pivot Tables via VBA — Step-by-Step Tutorial
• Pivot Tables via VBA — Code Examples
• Pivot Tables via VBA — Common Errors & Fixes
• Pivot Tables via VBA — Best Practices
• Pivot Tables via VBA — Advanced Techniques
• AutoFilter via VBA
• AutoFilter via VBA — Step-by-Step Tutorial
• AutoFilter via VBA — Code Examples
• AutoFilter via VBA — Common Errors & Fixes
• AutoFilter via VBA — Best Practices
• AutoFilter via VBA — Advanced Techniques
• Advanced Filter via VBA
• Advanced Filter via VBA — Step-by-Step Tutorial
• Advanced Filter via VBA — Code Examples
• Advanced Filter via VBA — Common Errors & Fixes
• Advanced Filter via VBA — Best Practices
• Advanced Filter via VBA — Advanced Techniques
• Working with External Data
• Working with External Data — Step-by-Step Tutorial
• Working with External Data — Code Examples
• Working with External Data — Common Errors & Fixes
• Working with External Data — Best Practices
• Working with External Data — Advanced Techniques
• ADO Connections
• ADO Connections — Step-by-Step Tutorial
• ADO Connections — Code Examples
• ADO Connections — Common Errors & Fixes
• ADO Connections — Best Practices
• ADO Connections — Advanced Techniques
• SQL Queries in VBA
• SQL Queries in VBA — Step-by-Step Tutorial
• SQL Queries in VBA — Code Examples
• SQL Queries in VBA — Common Errors & Fixes
• SQL Queries in VBA — Best Practices
• SQL Queries in VBA — Advanced Techniques
• Web Scraping with VBA
• Web Scraping with VBA — Step-by-Step Tutorial
• Web Scraping with VBA — Code Examples
• Web Scraping with VBA — Common Errors & Fixes
• Web Scraping with VBA — Best Practices
• Web Scraping with VBA — Advanced Techniques
• Regular Expressions
• Regular Expressions — Step-by-Step Tutorial
• Regular Expressions — Code Examples
• Regular Expressions — Common Errors & Fixes
• Regular Expressions — Best Practices
• Regular Expressions — Advanced Techniques
• Class Modules
• Class Modules — Step-by-Step Tutorial
• Class Modules — Code Examples
• Class Modules — Common Errors & Fixes
• Class Modules — Best Practices
• Class Modules — Advanced Techniques
• Events in VBA
• Events in VBA — Step-by-Step Tutorial
• Events in VBA — Code Examples
• Events in VBA — Common Errors & Fixes
• Events in VBA — Best Practices
• Events in VBA — Advanced Techniques
• Worksheet Events
• Worksheet Events — Step-by-Step Tutorial
• Worksheet Events — Code Examples
• Worksheet Events — Common Errors & Fixes
• Worksheet Events — Best Practices
• Worksheet Events — Advanced Techniques
• Workbook Events
• Workbook Events — Step-by-Step Tutorial
• Workbook Events — Code Examples
• Workbook Events — Common Errors & Fixes
• Workbook Events — Best Practices
• Workbook Events — Advanced Techniques
• Application Events
• Application Events — Step-by-Step Tutorial
• Application Events — Code Examples
• Application Events — Common Errors & Fixes
• Application Events — Best Practices
• Application Events — Advanced Techniques
• Custom Functions UDF
• Custom Functions UDF — Step-by-Step Tutorial
• Custom Functions UDF — Code Examples
• Custom Functions UDF — Common Errors & Fixes
• Custom Functions UDF — Best Practices
• Custom Functions UDF — Advanced Techniques
• Add-in Development
• Add-in Development — Step-by-Step Tutorial
• Add-in Development — Code Examples
• Add-in Development — Common Errors & Fixes
• Add-in Development — Best Practices
• Add-in Development — Advanced Techniques
• Ribbon Customization
• Ribbon Customization — Step-by-Step Tutorial
• Ribbon Customization — Code Examples
• Ribbon Customization — Common Errors & Fixes
• Ribbon Customization — Best Practices
• Ribbon Customization — Advanced Techniques
• Working with Shapes
• Working with Shapes — Step-by-Step Tutorial
• Working with Shapes — Code Examples
• Working with Shapes — Common Errors & Fixes
• Working with Shapes — Best Practices
• Working with Shapes — Advanced Techniques
• Working with Comments
• Working with Comments — Step-by-Step Tutorial
• Working with Comments — Code Examples
• Working with Comments — Common Errors & Fixes
• Working with Comments — Best Practices
• Working with Comments — Advanced Techniques
• Print Settings via VBA
• Print Settings via VBA — Step-by-Step Tutorial
• Print Settings via VBA — Code Examples
• Print Settings via VBA — Common Errors & Fixes
• Print Settings via VBA — Best Practices
• Print Settings via VBA — Advanced Techniques
• Performance Optimization VBA
• Performance Optimization VBA — Step-by-Step Tutorial
• Performance Optimization VBA — Code Examples
• Performance Optimization VBA — Common Errors & Fixes
• Performance Optimization VBA — Best Practices
• Performance Optimization VBA — Advanced Techniques
• Debugging VBA Code
• Debugging VBA Code — Step-by-Step Tutorial
• Debugging VBA Code — Code Examples
• Debugging VBA Code — Common Errors & Fixes
• Debugging VBA Code — Best Practices
• Debugging VBA Code — Advanced Techniques
• Immediate Window
• Immediate Window — Step-by-Step Tutorial
• Immediate Window — Code Examples
• Immediate Window — Common Errors & Fixes
• Immediate Window — Best Practices
• Immediate Window — Advanced Techniques
• Watch Window
• Watch Window — Step-by-Step Tutorial
• Watch Window — Code Examples
• Watch Window — Common Errors & Fixes
• Watch Window — Best Practices
• Watch Window — Advanced Techniques
• Breakpoints
• Breakpoints — Step-by-Step Tutorial
• Breakpoints — Code Examples
• Breakpoints — Common Errors & Fixes
• Breakpoints — Best Practices
• Breakpoints — Advanced Techniques
• Step Through Code
• Step Through Code — Step-by-Step Tutorial
• Step Through Code — Code Examples
• Step Through Code — Common Errors & Fixes
• Step Through Code — Best Practices
• Step Through Code — Advanced Techniques
• VBA Security Settings
• VBA Security Settings — Step-by-Step Tutorial
• VBA Security Settings — Code Examples
• VBA Security Settings — Common Errors & Fixes
• VBA Security Settings — Best Practices
• VBA Security Settings — Advanced Techniques
• Digital Signatures for Macros
• Digital Signatures for Macros — Step-by-Step Tutorial
• Digital Signatures for Macros — Code Examples
• Digital Signatures for Macros — Common Errors & Fixes
• Digital Signatures for Macros — Best Practices
• Digital Signatures for Macros — Advanced Techniques
• Password Protecting VBA
• Password Protecting VBA — Step-by-Step Tutorial
• Password Protecting VBA — Code Examples
• Password Protecting VBA — Common Errors & Fixes
• Password Protecting VBA — Best Practices
• Password Protecting VBA — Advanced Techniques
• Dictionary Object
• Dictionary Object — Step-by-Step Tutorial
• Dictionary Object — Code Examples
• Dictionary Object — Common Errors & Fixes
• Dictionary Object — Best Practices
• Dictionary Object — Advanced Techniques
• Collection Object
• Collection Object — Step-by-Step Tutorial
• Collection Object — Code Examples
• Collection Object — Common Errors & Fixes
• Collection Object — Best Practices
• Collection Object — Advanced Techniques
• FileSystemObject
• FileSystemObject — Step-by-Step Tutorial
• FileSystemObject — Code Examples
• FileSystemObject — Common Errors & Fixes
• FileSystemObject — Best Practices
• FileSystemObject — Advanced Techniques
• Windows API Calls
• Windows API Calls — Step-by-Step Tutorial
• Windows API Calls — Code Examples
• Windows API Calls — Common Errors & Fixes
• Windows API Calls — Best Practices
• Windows API Calls — Advanced Techniques
• Timer Functions
• Timer Functions — Step-by-Step Tutorial
• Timer Functions — Code Examples
• Timer Functions — Common Errors & Fixes
• Timer Functions — Best Practices
• Timer Functions — Advanced Techniques
• Clipboard Operations
• Clipboard Operations — Step-by-Step Tutorial
• Clipboard Operations — Code Examples
• Clipboard Operations — Common Errors & Fixes
• Clipboard Operations — Best Practices
• Clipboard Operations — Advanced Techniques
• Working with XML
• Working with XML — Step-by-Step Tutorial
• Working with XML — Code Examples
• Working with XML — Common Errors & Fixes
• Working with XML — Best Practices
• Working with XML — Advanced Techniques
• Working with JSON
• Working with JSON — Step-by-Step Tutorial
• Working with JSON — Code Examples
• Working with JSON — Common Errors & Fixes
• Working with JSON — Best Practices
• Working with JSON — Advanced Techniques
• Working with CSV Files
• Working with CSV Files — Step-by-Step Tutorial
• Working with CSV Files — Code Examples
• Working with CSV Files — Common Errors & Fixes
• Working with CSV Files — Best Practices
• Working with CSV Files — Advanced Techniques
• Automating Word from Excel
• Automating Word from Excel — Step-by-Step Tutorial
• Automating Word from Excel — Code Examples
• Automating Word from Excel — Common Errors & Fixes
• Automating Word from Excel — Best Practices
• Automating Word from Excel — Advanced Techniques
• Automating PowerPoint from Excel
• Automating PowerPoint from Excel — Step-by-Step Tutorial
• Automating PowerPoint from Excel — Code Examples
• Automating PowerPoint from Excel — Common Errors & Fixes
• Automating PowerPoint from Excel — Best Practices
• Automating PowerPoint from Excel — Advanced Techniques
• Automating Outlook from Excel
• Automating Outlook from Excel — Step-by-Step Tutorial
• Automating Outlook from Excel — Code Examples
• Automating Outlook from Excel — Common Errors & Fixes
• Automating Outlook from Excel — Best Practices
• Automating Outlook from Excel — Advanced Techniques
• Automating Access from Excel
• Automating Access from Excel — Step-by-Step Tutorial
• Automating Access from Excel — Code Examples
• Automating Access from Excel — Common Errors & Fixes
• Automating Access from Excel — Best Practices
• Automating Access from Excel — Advanced Techniques
• VBA Best Practices
• VBA Best Practices — Step-by-Step Tutorial
• VBA Best Practices — Code Examples
• VBA Best Practices — Common Errors & Fixes
• VBA Best Practices — Best Practices
• VBA Best Practices — Advanced Techniques
• Code Organization
• Code Organization — Step-by-Step Tutorial
• Code Organization — Code Examples
• Code Organization — Common Errors & Fixes
• Code Organization — Best Practices
• Code Organization — Advanced Techniques
• Naming Conventions
• Naming Conventions — Step-by-Step Tutorial
• Naming Conventions — Code Examples
• Naming Conventions — Common Errors & Fixes
• Naming Conventions — Best Practices
• Naming Conventions — Advanced Techniques
• VBA Runtime Error 1004: Application-defined or Object-defined Error
• VBA Runtime Error 9: Subscript Out of Range
• VBA Runtime Error 13: Type Mismatch
• VBA Runtime Error 91: Object Variable Not Set
• VBA Runtime Error 424: Object Required
• VBA Runtime Error 438: Object Doesn't Support This Property or Method
• VBA Runtime Error 1004: Method Range of Object Worksheet Failed
• VBA Runtime Error 70: Permission Denied
• VBA Runtime Error 53: File Not Found
• VBA Runtime Error 75: Path/File Access Error
• VBA Runtime Error 76: Path Not Found
• VBA Runtime Error 6: Overflow
• VBA Runtime Error 11: Division by Zero
• VBA Runtime Error 5: Invalid Procedure Call
• VBA Runtime Error 7: Out of Memory
• VBA Runtime Error 28: Out of Stack Space
• VBA Runtime Error 35: Sub or Function Not Defined
• VBA Runtime Error 48: Error in Loading DLL
• VBA Runtime Error 429: ActiveX Component Can't Create Object
• VBA Runtime Error 432: File Name or Class Name Not Found
• VBA Runtime Error 440: Automation Error
• VBA Runtime Error 445: Object Doesn't Support This Action
• VBA Runtime Error 449: Argument Not Optional
• VBA Runtime Error 450: Wrong Number of Arguments
• VBA Runtime Error 451: Property Let Procedure Not Defined
• VBA Runtime Error 452: Invalid Ordinal
• VBA Runtime Error 453: Specified DLL Function Not Found
• VBA Runtime Error 457: Key Already Associated
• VBA Runtime Error 461: Method or Data Member Not Found
• VBA Runtime Error 462: Remote Server Machine Does Not Exist