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 …
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 …
The aesthetic design of a spreadsheet, when done right, can add significant benefits in terms of usability and functionality.
The next few posts will focus on layout. While layout was previously discussed in some detail (listboxes and forms), we are yet to dive into overarching layout ideas and approaches.
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.
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.
Navigating through an Excel workbook should be like navigating through a well designed website. By approaching projects with the mindset of good design, you can ensure great usability standards.