Getting the Most Out of Subroutines in VBA

Up until this point of the series, the Sub statement–short for subroutine–has been one of the most frequently used statements in tutorials and exercises. In their plain vanilla form, a subroutines serve one purpose — to contain procedural code. However, having a comprehensive understanding of how subroutines work and various …

VBA Productivity Tip: Intellisense

This post introduces our first VBA Productivity Tip, a summary of the VBA Editor’s intellisense feature. Intellisense can help reduce the occurrence of common syntactical and semantic errors by providing useful tooltips and lists to help you code more efficiently.

Organize Code with User-Defined Types in VBA

VBA data structures such as arrays, collections, and enumerations can help organize large and complex sets of data. When drilling down to specifics within data, it can be somewhat difficult to work with these structures. VBA offers another data structure, User-Defined Types, which provide a more intuitive and user friendly …

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.

Data Input for Datasets in Excel with VBA

While Excel provides the means of entering data directly into datasets, you can build important controls and features by processing data through a VBA script. This post will provide an overview of a user-friendly data input form to prepare data for processing and entry in VBA.