Determining the Most Appropriate User Interface

When you develop spreadsheets that others will use, you need to pay special attention to the user interface. By user interface, I mean the method by which the user interacts with the application and executes your VBA macros.

Excel 2007 makes some of these decisions irrelevant. Custom menus and toolbars are, for all intents and purposes, obsolete. This means that developers must learn how to work with the Ribbon.

Excel provides several features that are relevant to user interface design:

■ Ribbon customizations

■ Shortcut menu customization

■ Shortcut keys

■ Custom dialog boxes (UserForms)

■ Controls (such as a ListBox or a CommandButton) placed directly on a worksheet

I discuss these features briefly in the following sections and cover them more thoroughly in later chapters.

0 0

Post a comment