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.

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.