Chapter 4. Worksheet Design
There is a tremendous amount of Excel user interface design that can and should be accomplished using the built-in features of Excel alone, with no VBA required. One of the guiding principles of Excel development is "let Excel be Excel." Don't try to reinvent the wheel. Excel provides a wide variety of prepackaged, performance-optimized features you can use to build your application's user interface. This chapter examines how you can produce a fully functional user interface with just the features Excel provides for this purpose. There are two fundamental sections of an Excel worksheet user interface: those designed to be visible to the user and through which the user operates your application, and those designed to be hidden from the user and used only by your application to perform the tasks required of it. We cover each of these sections in more detail in this chapter.
|