The VBA Tutorials Blog
Excel VBA Tutorials
Two ways to activate a program with VBA if already open
Nov 20, 2015
You know how to open a program, file or folder with VBA Shell, but how do you activate an application that is already open? Keep reading to discover how!
Draw Lines or Arrows Between Cells with VBA
Oct 30, 2015
Use this macro to draw lines or arrows between two cells in Excel. This is great for finding matches in data sets or comparing locations in Excel maps.
Excel Advent Calendar Contest
Oct 9, 2015
Countdown the days to Christmas and enter for your chance to win a VBA Christmas gift with this interactive Excel Advent Calendar from Spreadsheet1.
Call VBA VLookup Function with Application.WorksheetFunction
Sep 25, 2015
Use Application.WorksheetFunction to call vlookup, min, max and many more built-in Excel functions directly from your VBA macro. This tutorial will show you how.
Use VBA CStr to Convert Number to String
Sep 18, 2015
Learn how to use the VBA CStr function to convert a number to a string. CStr can also be used to convert a date to a string using VBA.
Convert String to Integer with VBA CInt
Sep 11, 2015
This VBA tutorial shows you how to convert a data type from a string to an integer with the VBA Type Conversion function CInt. Robust error checks included!
VBA ColorIndex Color Infographic
Aug 25, 2015
Knowing VBA colors is handy when designing Excel spreadsheets and userforms. This infographic shows you the 8 named color constants and 56 ColorIndex colors for VBA.
Unicode, Decimal, ASCII and more with VBA StrConv
Aug 21, 2015
Use the VBA StrConv function to convert strings to upper, lower or proper case. The powerful StrConv function even has built in support for converting to Unicode.
VBA Copy to Clipboard, Paste and Clear
Aug 14, 2015
Use VBA to copy to your clipboard, paste from your clipboard and clear the contents of your clipboard. These macros work with Excel, Outlook, Word and more.
Mouse To Macro Excel Add-in
Jul 31, 2015
Mouse To Macro is an Excel Add-in that records your mouse clicks and cursor movements and converts the actions to a VBA macro for instant playback.
Coming Fall 2017
Auto-Import Macros Directly from wellsr.com
when you join the waitlist
Tell Me More
Sign up for my Mastering VBA Newsletter
And get the power of wellsr.com right in Excel with a FREE copy of my Excel Add-In.
Most Popular Posts
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
Latest Blog Posts
Excel VBA Assign Range to Array
Beautiful VBA Progress Bar with Step by Step Instructions
VBA Column Number to Letter
Excel VBA Delete Blank Rows
Transparent UserForm Background with VBA
VBA RoundUp WorksheetFunction to Round Up
Excel VBA Tutorials
Chapter 1: Getting Started
Enable Developer Tab
Open Visual Basic Editor
Create your first Macro
Recording a Macro
Chapter 2: Getting Around
Select and Selection
Chapter 3: Variables and Data Types
VBA Data Types
Variable Scope & Lifetime
More Excel VBA Tutorials