The VBA Tutorials Blog
Learn VBA Code Online for Free
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.
Excel VBA Tutorials
4 Useful VBA Delete Worksheet Macro Examples
May 27, 2016
This tutorial shows you 4 ways to delete worksheets using VBA macros, including how to delete sheets without the warning prompt.
Add Hyperlinks to Word References with VBA
May 14, 2016
This tutorial will show you how to quickly add hyperlinks to the references in your Word document using a VBA macro.
Loop through Array with VBA UBound
Apr 29, 2016
Use the VBA UBound function to loop through all the elements in an array. The VBA UBound function returns the size of an array dimension.
The Complete Guide to Excel VBA Form Control ListBoxes
Apr 16, 2016
This guide will teach you everything you want to know about using the Excel Form Control ListBox with VBA, including adding an item and selecting an item.
Offset VBA Property to Navigate Excel
Apr 8, 2016
This tutorial shows you how the offset VBA property is used to navigate Excel. In VBA, offset allows you to access cells relative to your target cell.
Compare Cells with this Excel VBA Function
Apr 1, 2016
This Excel VBA Function will compare two cells and return whether or not the cells are identical. Use it to compare data from two different sources.
Powerful Excel Linear Interpolation Function with VBA
Mar 24, 2016
This simple and powerful Excel linear interpolation user defined function was developed using VBA and does not require your data tables be sorted.
Create an Awesome Excel Splash Screen For Your Spreadsheet
Feb 26, 2016
Give your spreadsheet the grand entrance it deserves by designing and launching an awesome animated splash screen when your workbook is opened.
Extract URLs and Folder Paths with VBA InStrRev
Feb 19, 2016
VBA InStrRev searches for a substring inside a string or cell, starting from right to left. InStrRev is great for extracting URLs or folder paths from text.
The Complete Guide to Excel Form Control Option Button VBA
Jan 31, 2016
This guide will teach you everything you want to know about using the Excel Form Control Option Button with VBA. Option buttons are also called radio buttons.
Get these macros delivered right to your spreadsheet for free
Access tutorials and import my macros without ever leaving Excel
Show me - It's free
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
VBA Scroll with ScrollRow and ScrollColumn
VBA - Remove Duplicates from Array
VBA Comment Block of Lines
VBA Application.StatusBar to Mark Progress
VBA MacroOptions to Add UDF Description
Combine PDFs with VBA and Adobe Acrobat
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