Subscribe via RSS
Looking for Excel VBA Tutorials?

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!

Ultimate VBA Training Bundle

$100.00 $52.00

We've combined each of our comprehensive wellsrPRO VBA training reference guides into a single bundle with over 180 tips and macros covering the 100 most important topics in VBA.

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.

Mouse to Macro Excel Add-in

$15.00

Use Excel to record your mouse clicks and cursor movements and convert them directly into VBA macros so you can easily automate complex tasks, like copying data from a website.

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.

Using Excel VBA to Send Emails with Attachments

Aug 8, 2018

This tutorial will demonstrate how to use Excel VBA to send emails with attachments, and we will take a detailed look at the Attachments object, which is actually a collection. It's quite easy to attach files to an email using Excel VBA.

VBA DoEvents and when to use it

Aug 3, 2018

VBA DoEvents yields execution of your macro, so your computer processor will be able to simultaneously run other tasks. The VBA DoEvents function also enables interruption of code execution so it's easier to stop a running macro.

VBA Send Email from Excel

Aug 1, 2018

Use VBA to send emails from Excel with Outlook. This tutorial provides a macro for sending emails from Excel, tells you how to use Excel VBA to send emails with attachments and add a body to your emails.

subscribe via RSS