Subscribe via RSS
Looking for Excel VBA Tutorials?
VBA Cheat Sheets to help you write macros
These VBA Cheat Sheets are full of tips and macro examples covering the 50 most important topics in VBA. Grab a couple of our VBA cheat sheets and start taking your macro skills to the next level.
-
VBA Transpose to switch rows and columns
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.
-
Format Numbers with VBA NumberFormat
This tutorial teaches you how to format numbers in Excel using the VBA NumberFormat property. The VBA NumberFormat property can control the appearance of decimals, commas and can even format text.
-
How to create VBA User Defined Functions in Excel
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
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.
-
Read and Write to a Text File with VBA OpenTextFile
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
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
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!
-
Excel VBA Dictionary Keys and Items
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
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
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.
subscribe via RSS
