wellsr.com
  • VBA Tutorials
  • Python Tutorials
  • VBA Cheat Sheets
  • Consulting

VBA Code and Macro Examples

The VBA Tutorials Blog

VBA Code and Macro Examples

Archived posts from this category

  • Word VBA Saves Pages as Separate PDFs

    Mar 30, 2015

  • Outlook Search not working? Use VBA

    Mar 22, 2015

  • VBA Office Prank Dancing Banana Cursor

    Mar 21, 2015

  • Compare Two Excel Columns for Differences

    Mar 14, 2015

  • Trapezoidal Rule Excel Function

    Feb 15, 2015

  • DIY Desktop Exercise Reminder

    Feb 15, 2015
New to VBA? Start here
Chapter 1: How to create a macro in Excel
Enable Excel Developer Tab
Open VBA Editor in Excel
Writing a macro
Using the Macro Recorder
Commenting in VBA

Chapter 2: Navigating your spreadsheet with VBA
Using the VBA Range object
How to select cells with VBA
Controlling different workbooks
Macros to control worksheets

Chapter 3: Understanding VBA Variables
VBA Variable Types
How to Declare Variables
Variable Scope and Lifetime
Understanding Option Explicit

Free VBA Kit

We wrote the Big Book of Excel VBA Macros and built a VBA Developer Kit designed to help you write better macros in half the time.

I want a free VBA ebook and Dev Kit.
Programming Language

Popular VBA Tutorials
3 Ways to Call a Private Sub from Another Module
Run Excel Macro Without Opening Excel
Open and Close File with VBA Shell
Create an Excel Splash Screen for your Spreadsheet
The Complete Guide to Excel VBA Form Control Checkboxes
Make Dot Grid Paper with Word Document
Beautiful VBA Progress Bar with Step by Step Instructions
Show System Tray Notification Balloon when your Macro is done

VBA Cheat Sheet Bundle
Latest VBA Tutorials
FormulaR1C1 Makes Relative References in VBA Easy
Use VBA Range.Find to Search and Retrieve Data
VBA AdvancedFilter with Multiple Criteria
VBA Sgn Function to Check for Positive or Negative Numbers
How to Filter a Column with VBA AutoFilter
VBA Filter Unique Values with AdvancedFilter

The VBA Tutorials Blog with Ryan Wells

  • VBA Code and Macro Examples
  • Privacy Policy
  • RSS
  • Twitter
  • GitHub
  • LinkedIn

Each VBA Tutorial contains macro examples to help you learn VBA code quickly. Follow these VBA tutorials to learn basic and advanced Excel macro programming.