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.
Ultimate VBA Training Bundle
$80.00 $52.00
We've combined each of our comprehensive wellsrPRO VBA training reference guides into a single bundle with over 150 tips and macros covering the 80 most important topics in VBA.
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.
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.
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.
VBA Copy a file with FSO CopyFile
Jul 27, 2018
The FSO CopyFile method is a quick VBA way to copy a file from one location to another. Use the VBA CopyFile FileSystemObject (FSO) function to copy a file to another folder.
How to Populate ComboBox on VBA Userforms
Jul 25, 2018
There are two ways to populate a combobox with VBA: List and AddItem. Learn how to populate userform comboboxes statically and dynamically with this VBA tutorial.
subscribe via RSS
