Chapter 4. Worksheet Design
A tremendous amount of Excel user interface design 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. In this chapter we examine 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 ...
Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition 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.
