The VBA Tutorials Blog
Excel VBA Tutorials
Use IsEmpty VBA to Check if Cell is Blank
Jun 16, 2016
Use the IsEmpty VBA function to check if a cell is blank. When used on a range, the IsEmpty VBA function behaves like the Excel ISBLANK function.
IsNumeric VBA Function Checks if Cell is a Number
Jun 10, 2016
The IsNumeric VBA function checks if a cell is a number and returns True or False. The IsNumeric VBA function is a counterpart to the Excel ISNUMBER function.
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.
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
Show System Tray Notification Balloon when Macro is Done
VBA Dir Function to Check if File Exists
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
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