The VBA Tutorials Blog
Excel VBA Tutorials
Easily Extract Text Between Two Strings with VBA
Aug 31, 2016
Easily extract text between two strings with this VBA Function. This function can extract a substring between two characters, delimiters, words and more.
VBA Replace Function to Replace Characters in a String
Aug 28, 2016
Use the VBA Replace function to replace a substring of characters in a string with a new string. VBA Replace is similar to the Excel SUBSTITUTE function.
Replace Nth Occurrence of a Substring in a String with VBA
Aug 27, 2016
Replace the Nth occurrence of a substring in a string with this VBA UDF. Use it to replace the 2nd, 3rd, 4th or more instance of a string within another string.
Make Excel Talk with Application.Speech.Speak VBA
Aug 26, 2016
Make Excel talk with Application.Speech.Speak VBA and discover how to change the voice, speed and volume with the sapi.dll Microsoft Speech Object Library.
Convert Decimal Time to Hours Minutes Seconds with VBA
Aug 19, 2016
This VBA function converts decimal times in Excel to words. 10.5 becomes 10 Minutes 30 Seconds. It can convert base times given in hours, minutes or seconds.
Use VBA ShellExecute to Open URL in Default Browser
Aug 12, 2016
Use the VBA ShellExecute function to open a URL in the default browser. VBA ShellExecute is a better choice than opening each website in internet explorer.
VBA Beep Sound on Error
Aug 5, 2016
The VBA Beep function lets you play a system beep sound whenever you like. VBA Beep usually comes through your speakers so make sure your volume is up.
VBA Count Files in Folder
Aug 1, 2016
Use this VBA macro to count the files in a folder. This macro can return the number of total files in a folder or the number of files of a certain type.
VBA Loop Through Files in Folder
Jul 29, 2016
Loop through files in a folder with this VBA macro. Use it anytime you need to check each file in a folder or when you want to list the files in a folder.
Mask your Password with this VBA InputBox
Jul 28, 2016
Use this VBA InputBox to mask passwords. This private InputBox was originally created by Daniel Klann many years ago, but I'll teach you how to use it.
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