VBScript Code Examples and Tutorials
Archived posts from this category
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.
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