Case Study: Custom VBA Tooltips

This post provides a case study of an advanced implementation of custom VBA tooltips. While Excel offers a built-in tooltips feature for data validation, its limited to displaying simple text messages. By implementing custom tooltips through VBA, you can provide users with dynamic validation hints and infographics.

Easy VBA Tooltips

One of the most difficult parts of spreadsheet design relates to making complex spreadsheets accessible to all users. In business settings, a select group may be trained on how to use a spreadsheet model, but staff turnover may result in training gaps. This is where instructions embedded within a spreadsheet—such …

10 Assumptions to Avoid in VBA

Even experienced VBA developers struggle to foresee issues that may come up at a future point. Whether during development, or after a program is rolled out to users, bugs and glitches can lead to headaches and awkward explanations. To help avoid these issues and ensure our VBA projects run as …

10 Non-VBA Concepts Important for VBA Developers

As a VBA developer, it’s important not to lose sight of the broader Excel application environment. VBA will always be part of Excel — an application containing its own interface, features, and functionality. This post will provide an overview of 10 important non-VBA concepts and features important for VBA developers …

10 Tips for Great Spreadsheet Aesthetics and Design

The aesthetic design of a spreadsheet, when done right, can add significant benefits in terms of usability and functionality.

Building a Custom Listbox in Excel with Formulas

As discussed in previous posts, separating users from raw datasets is a cornerstone of excellent spreadsheet design. Today’s post provides a non-VBA solution to displaying data to users through a dynamic custom listbox.

Navigation in Excel with VBA

Using VBA to control navigation elements of a spreadsheet provides a greater level of flexibility. Through proper coding, users will be provided with responsive navigation and proper feedback.