The VBA Tutorials Blog
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.
Discover how this Nuclear Engineer Mastered Excel VBA
And why you should, too
Your time is valuable. It's time to become a VBA expert.
Subscribe to wellsr.com
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
Match Value in Range to Same Position in Another Range
Remove Window Border Title Bar around UserForm with VBA
VBA to Only Allow Numbers in Cell or Range
Macro to Enable Trust Access to the VBA Project Object Model
Wait Until a Key is Pressed with GetAsyncKeyState VBA
VBA TextBox Numbers Only using Keypress KeyAscii
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