Subscribe via RSS
Looking for Excel VBA Tutorials?

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