Excel VBA References:
- Excel VBA Resources: Sample functions and explanations for Excel VBA
List of Excel VBA Tutorials:
VBA Tutorial Group: From Beginner to Intermediate
- Excel Visual Basic #1: Getting Started: Beginner Level – Basic introduction to Excel VBA. Goes through how to get started and guides you to complete your first application using Excel VBA.
- Excel Visual Basic #2: Variables and Decisions: Beginner Level – Covers variables and decision/control structures. Guides the completion of your first application with variables and If…Then…Else decision structures in Excel VBA.
- Excel Visual Basic #3: Loops, Combo Boxes, and Saving: Beginner Level – Introduces you to loops, other form functions like combo boxes, and goes through how to save your macro-enabled excel workbook.
- Excel Visual Basic #4: Create A Web Favorites List: Intermediate Level – Combines the first three tutorials in this set to create a more advanced application. The end result is a list you can add your favorite web pages to and open them up in your default web browser.
VBA Tutorial Group: Forms and Duplicating Sheets
- Excel Visual Basic #5: Duplicating Sheets: Intermediate Level – Goes through the process of creating new sheets programmatically based on an existing sheet.
Selenium Basic Tutorial: Excel Automation
- Hacking Excel: Installing Selenium Basic: Beginner Level – Introduction to Selenium Basic
- Hacking Excel: Creating a Search box Automation Tool: Intermediate Level – Guest author post on “The Hack Post”
Books and Educational Material on Excel VBA