The VBA Tutorials Blog
Excel VBA Tutorials
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.
Show Color Palette Dialog Box with VBA xlDialogEditColor
Jul 22, 2016
Now your Excel users can select their own colors when running your macro! I'll show you how to show a Color Palette Dialog Box using VBA xlDialogEditColor.
Export Outlook Contacts to Excel with VBA
Jul 11, 2016
Use VBA to export your Outlook Contacts to Excel. With VBA macros, you can choose which Outlook Address Book properties you want to export to Excel.
Application Volatile VBA to Recalculate Function
Jul 7, 2016
Placing Application.Volatile at the top of your custom VBA function makes your function recalculate each time a calculation occurs in another cell.
Check if Value is in Array using VBA
Jul 4, 2016
Check if a value is in an array with this VBA function. Use it to look for a string in a string array, an integer in an integer array, and more.
How to Change Another Cell with a VBA Function
Jul 1, 2016
Despite what others say, it is possible to change another cell with a VBA user-defined function. These UDFs put the results of the formula in a different cell.
VBA to Maximize Window in Left Monitor
Jun 28, 2016
Move your window to the left screen and maximize it with VBA. Placing your window in a consistent position is a must before using mouse control macros.
Open Folder using VBA and Show if Already Open
Jun 25, 2016
This macro opens a folder using VBA or shows the open window if the folder is already opened. Pass the macro a string with the folder you want to open.
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