Use VBA Workbook event handling to capture a variety of application-level events. The events captured in the VBA ThisWorkbook module can be used to trigger unique actions based on a user's interaction with Excel.
Use VBA collections to group key-item pairs of related data, kind of like scripting dictionaries. The VBA Collection object is default class in Excel so it doesn't require a reference to an object library.
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.
Use VBA transpose to switch rows and columns in Excel. The VBA transpose function is helpful for converting rows to columns and columns to rows. In this tutorial, a macro that transposes both data and formatting is presented.
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.
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.