Series Highlights and VBA Cheat Sheet

As we approach the close of the Getting Started with VBA series, it’s important to take a broad look at all topics discussed. This post will act as a reference for general syntax, concepts, and other topics.

The Range Object – Let VBA Talk to the Spreadsheet

If you’re interested in learning VBA, that means you want to write scripts that interact with a spreadsheet. The foundation of this interaction is the Range Object. The Range Object contains all the necessary features and tools to make your VBA scripts speak to a spreadsheet.

Getting Started with the VBA Editor

One of the great things about Excel is the ability to begin writing VBA code with as few as two clicks upon opening a new workbook. This ease of access allows almost anyone to become a programmer. This post will provide a general tour of the VBA editor.

Create Dynamic Spreadsheets with Conditional Formatting

Conditional formatting is a built-in Excel feature that—with proper implementation—can provide very useful and responsive feedback to users. By providing dynamic visuals, users will be able to gain instant insights into data and dashboards.

Data Validation with Excel’s Built-In Data Validation Tools

Many developers will admit that when it comes to creating a user friendly application, more effort is often committed to controlling user inputs than actual functionality and design. Excel’s data validation tools allow you to easily deploy validation features on any spreadsheet project.