An application that allows its end users to customize it to their preferences exudes an air of professionalism. If you're working with a tightly locked-down workbook, this functionality assumes even greater importance because it may be the only way that users can customize the look of the application.

Not only can this kind of functionality enhance the professionalism of your applications, it also has the ability to save you time by reducing the amount of change requests you receive. For every person that wants data formatted or calculated a certain way, there is always someone else who wants it formatted the exact opposite or calculated in a different manner.

The fact that you can provide personalization in your applications is a prime example of the benefit of using classes. You can create classes that wrap up all of the necessary functionality and then drop these classes in any project that requires them. As you'll soon see, these classes are much more beneficial than I originally intended them to be. When you use the Setting and Settings classes, you can conceivably pull any variable you use in your program out of the VBE environment (your code) and onto a worksheet managed by these classes. This approach, often referred to as table-driven programming, allows people other than programmers to configure and modify the behavior of the application without having to understand the VBA code. In Chapter 20, you'll develop a User Form that works with these classes to manage the Settings visually.

In Chapter 13, you'll review some Excel development best practices. Some of this material will serve as a review of some of the best tips I've already given you. In addition, I'll discuss other development techniques that I've found valuable while developing Excel applications.

This page intentionally left blank

0 0

Post a comment