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 …
The VBA collection class provides a framework to support basic object structures. While its most common use a collection class to manage groups of custom objects, including new properties and methods permits extraction of key aggregate data points for the entire collection. Overview This is the eight post in the …
Class properties are typically simple statements which serve the basic purpose of reading or writing data in custom objects. However, it is possible to add additional lines of code, giving properties features similar to standard subroutines or functions.
With VBA, it’s possible to develop user input forms with data validation features and responses similar to those found on professional websites and desktop applications. In doing so, you can present the user with an familiar interface and user experience.
Today’s post continues the discussion on data validation, introducing a new approach that utilized Excel formulas. This approach provides an additional level of flexibility without the need for complex macros or VBA.
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.
While Excel provides the means of entering data directly into datasets, you can build important controls and features by processing data through a VBA script. This post will provide an overview of a user-friendly data input form to prepare data for processing and entry in VBA.
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.