Google-Like Search in Excel

Today’s post introduces a Google-like search, with search-as-you-type suggestions. While it’s possible to run basic searches with VLOOKUP and other techniques, this VBA approach can provide immediate search suggestions or recommendations for the user.

Storing Objects as Class Properties

In most situations, Excel objects, such as shapes and buttons, perform simple functions and stand on their own. However, when stored within a class, the opportunity exists to supplement the functionality of custom objects.

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 …

Modifying Data in Spreadsheets with VBA

While it’s usually obvious to a user how to add data in a spreadsheet, modifying data is often less obvious and an afterthought for many developers. By providing a clean and inutitive interface to modify data, inputs can be validated and controlled, ensuring datasets remain clean.

Building a Custom Listbox in Excel with VBA

While the Listbox Form and ActiveX control can suit the needs of many, they lack many options that provide full interactivity and customization. A custom VBA solution will give you full control of how listboxes look, and how users interact with them.

Data Management in Excel

Part 2 the Spreadsheet Design series will focus on Data Management, an often overlooked component of any large Excel project. This may well be because Excel is not meant to manage data; its primary purpose is to display data or derive analysis off of it.