Determining the most appropriate user interface

When you develop spreadsheets that others will use, pay special attention to the user interface. By user interface, I mean the method by which the user interacts with the application: clicking buttons, using menus, pressing keys, accessing toolbars, and so on.

Excel provides several features that relate to user-interface design:

i Dialog box controls placed directly on a worksheet i Custom dialog boxes (UserForms) i Custom menus i Custom toolbars i Custom shortcut keys

Consider all your options, as well as the skill level and motivation of the end users. Then decide on the interface elements that make the most sense.

0 0

Post a comment