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 ...
Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
