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.
Was this article helpful?