Welcome to Excel VBA
  • Introduction
Introduction to Visual Basic for Applications
  • Writing Code vs. Recording Macros
  • Understanding Objects
  • Containers & Collections
  • How VBA Refers to Objects
  • Security Settings
  • Section Summary
Understanding, Recording , and Modifying Macros
  • Recording Macros
  • Testing the Macro and Looking at the VBA
  • Absolute vs. Relative Mode
  • Recording in Relative Mode
  • Modifying Macros Using VBA
  • Assigning Macros to Shortcut Keys
  • Accessing Macros through the Quick Access Toolbar
  • Accessing Macros through the Ribbon
  • Accessing Macros through Shapes or Images
  • Accessing Macros through Command Buttons
  • Macro Example: Creating Buttons to Navigate Between Worksheets
  • Section Summary
Getting to Know the Visual Basic Editor
  • The Microsoft Visual Basic Editor
  • The Project Explorer
  • The Properties Window
  • The Code Window
  • Other Windows: the Immediate Window, the Locals Window, and the Watch Window
  • Docking Windows
  • Adding and Removing Modules
  • Exporting and Importing Modules
  • Naming Modules
  • Customizing the Visual Basic Environment
  • The Object Browser
  • Protecting Your Code
  • Section Summary
Getting Started with Programming VBA
  • Introduction to Writing VBA
  • A Few Time Savers Writing VBA
  • Resetting Your VBA Code Upon Errors
  • Structure of Sub Procedures
  • Calling a Sub Procedure
  • Structure of Functions
  • Calling a Function
  • Calling Procedures with the Same Name
  • Comments
  • Using Objects
  • Using Methods
  • Using Event Procedures - UPDATED
  • Section Summary
Getting to Know Variables, Data Types, and Operators
  • Variables
  • Declaring Multiple Variables
  • Object Variables
  • Data Types
  • Using Identifier Type Characers to Declare Data Types
  • Declaring Constants
  • Arithmetic Operators
  • Exercise: Using Byte Variables
  • Exercise: Using String Variables
  • Exercise: Using Currency Variables
  • Exercise: Using Date Variables
  • Logical Operators
  • The Colon Operator
  • String Concatenation
  • The Line Continuation Operator
  • Carriage Return Line Feed
  • The With Statement
  • Scope
  • Section Summary
Workbooks, Cells, and Ranges
  • Creating a New Workbook
  • Opening and Closing Workbooks
  • Worksheets vs. Sheets
  • ActiveSheet
  • Adding Worksheets
  • Copying Worksheets
  • Moving Worksheets
  • Deleting Worksheets
  • The Cells Object
  • Exercise: Using Operators and the Cells Object
  • ActiveCell
  • Rows and Columns
  • Inserting Columns and Rows
  • AutoFit Columns and Rows
  • The Range Object
  • Referring to Named Ranges
  • The Select Method
  • The CurrentRegion Property
  • The Range.End Property
  • Copying Data on Your Worksheet
  • The Paste Method
  • Using PasteSpecial
  • Useful Font Object Members
  • Clearing Contents and Formats
  • The Name Property
  • The Value Property
  • Exercise: Using Name, and Value
  • Sorting Fields
  • Filtering Fields