Excel Interface Design and Controls: Adding Buttons, Textboxes, Checkboxes, and Forms, Assignments of Introduction to Business Management

Download Excel Interface Design and Controls: Adding Buttons, Textboxes, Checkboxes, and Forms and more Assignments Introduction to Business Management in PDF only on Docsity! 1 Lecture 05 -Adding Controls -User Forms Goals for Today Reinforce everything we learned thus far Catch our breath Take the next step in programming Do some hands on work Today Review HW2 Briefly talk about interface design in Excel Hands on work with controls Intro to Forms Print Dialog Box Exercise Worksheet Design Balance letting Excel be Excel and guiding the user Two fundamental sections: Visible to the user, user operates your application Hidden to the user, used by the application to perform tasks 2 Some Good Principles Use formatting to create visual contrast between cells of different purposes (input, output, formula) Visually separate different sections of the interface Use consistent formatting for same-purpose cells Formatting should not detract from task Each interface should logically flow left to right, top to bottom Guide the user Worksheets should flow left to right Some Good Principles (cont) Make the user’s next step obvious Cell comments, validation lists, default values, good descriptive field names Use dynamic input-verification techniques, do not wait until end Do not allow catastrophes Protect worksheets, only unlock cells requiring input, hide sheet tabs Do not allow the user to get lost VBA Controls Controls Types Form Controls Single Event Active X controls Multiple Events Control Toolbox Complies to the Active X set of rules Can only run on Windows platform 5 What About Forms Create, show, unload Available controls Example Basics VBE: Insert | userform frmInput.Load frmInput.unload frmInput.show frmInput.hide Interface Design Checklist Are similar controls the same size? Are controls evenly spaced? Is the dialog box too overwhelming? Can group controls using groupbox or multipage Are controls grouped logically? Can controls be accessed with hot keys? Are hotkeys duplicated? Is tab order correct? Is everything spelled correctly? 6 Checklist Does the dialog box have an appropriate caption? What will happen if the user presses escape or the close button? Will the dialog box display correctly at different resolutions? Interface Design http://www.useit.com/papers/heuristic/heuristi c_list.html http://ldt.stanford.edu/~gimiller/Scenario- Based/scenarioIndex2.htm Project Print Dialog Box Exercise