How to create VBA User Defined Functions in Excel
Sep 14, 2018
Create your own functions in Excel with VBA user defined functions. VBA user defined functions allow you to perform complex calculations using lines of code rather than confusing nested Excel formulas.
VBA String Functions and how to use them
Sep 7, 2018
This tutorial describes VBA string functions, explains how to use basic VBA string functions, and guides you to detailed tutorials covering advanced VBA string functions.
Get your VBA Cheat Sheets
$120.00 $57.00
We've combined each of our comprehensive wellsrPRO VBA training reference guides into a single bundle with over 200 tips and macros covering the 125 most important topics in VBA.
Read and Write to a Text File with VBA OpenTextFile
Sep 7, 2018
You can use the FileSystemObject TextStream to open a text file in VBA by pairing it with the VBA OpenTextFile method. The VBA OpenTextFile method is a simple way to read, write, and append to text files.
Create Text File with FSO and VBA CreateTextFile
Aug 31, 2018
Use the FileSystemObject TextStream to create a text file with VBA CreateTextFile. The combination of TextStream and CreateTextFile make creating text files a breeze.
VBA Switch and VBA Select Case
Aug 30, 2018
This tutorial explains the difference between the VBA Switch function and the VBA Select Case statement. The VBA Select Case statement is sometimes called Switch Case, which can make distinguishing it from the Switch function rather confusing!
New VBA Cheat Sheet!
$120.00 $57.00
We just added a 6th cheat sheet to our training bundle. With our new guide on VBA UserForms, our bundle now has over 200 tips like how to automate data extraction from text files, how to remove duplicates from an array, and how to dynamically populate a listbox.
Excel VBA Dictionary Keys and Items
Aug 24, 2018
Use a VBA dictionary to create a collection of key-item pairs in Excel. The VBA dictionary object links keys to items so you can get your items later by simply calling the key.
Excel VBA AutoFilter to Filter Data Table
Aug 22, 2018
Use VBA AutoFilter to filter data in Excel. The VBA AutoFilter method lets you filter multiple fields at once and even filter on more than one criteria.
VBA Regex Regular Expressions Guide
Aug 19, 2018
VBA RegEx, or Regular Expressions, are special character sequences that define search patterns and are used to identify specific patterns of characters in a string. This tutorial will explain VBA RegEx pattern examples so you can create your own regular expressions.
VBA PasteSpecial Values, Formats, Formulas and more
Aug 17, 2018
Use the VBA PasteSpecial Method to paste values, formats, formulas and more. You can even use VBA PasteSpecial to perform math on entire ranges and transpose data.
VBA Select Files with msoFileDialogFilePicker
Aug 10, 2018
Use the VBA msoFileDialogFilePicker to browse for and select files with a macro. The msoFileDialogFilePicker property is part of the Application.FileDialog family in Excel and behaves much like the GetOpenFileName method.
subscribe via RSS
