Most Popular Posts of 2017

2017, this site’s first full year, is about to come to a close. In addition to wrapping up the Getting Started with VBA series early this fall, the Tips and Tricks with VBA Classes series is well under way and will conclude at the end of January. Below, you can …

Logical Operators for Conditional Statements in VBA

While the previous post explained how to use conditionals to execute specific blocks of code, the conditions were relatively strict, relying on single variables or liberal values. This post provides an overview of how to incorporate logical operators into conditional statements, permitting much needed flexibility with complex testing.

Using Conditional Statements in VBA

Previous posts on the Getting Started with VBA Series have focused on how to both extract information from cells on the spreadsheet, and create information in VBA with variables. While these may meet the needs of some simple programs, conditional statements open the door to creating responsive programs.

String and Numeric Functions

You are likely already familiar with many functions–such as ROUND or TRIM–that can be applied to cell values within a worksheet. VBA also contains a number of string and numeric functions that can be applied to variables.

Variables in VBA: An Overview

While the series has so far focused on VBA’s interaction with spreadsheets, there are endless opportunities for dynamic features and calculations which can occur off the spreadsheet.