Читать книгу Excel 2019 Power Programming with VBA - Michael Alexander, Dick Kusleika - Страница 40

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

Since the introduction of Excel 2007, some of these user interface decisions are irrelevant. Custom menus and toolbars are, for all intents and purposes, obsolete. Consequently, developers must learn how to work with the Ribbon.

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

 Ribbon customization

 Shortcut menu customization

 Shortcut keys

 Custom dialog boxes (UserForms)

 Message boxes and input boxes

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

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