Download Excel Interface Design and Controls: Adding Buttons, Textboxes, Checkboxes, and Forms and more Assignments Introduction to Business Management in PDF only on Docsity!
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 HW
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 guidingthe user
Two fundamental sections:
Visible to the user, user operates yourapplication
Hidden to the user, used by the application toperform tasks
Some Good Principles
Use formatting to create visual contrast between cells ofdifferent 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 tobottom ^ 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, gooddescriptive field names Use dynamic input-verification techniques, do not wait untilend Do not allow catastrophes ^ Protect worksheets, only unlock cells requiring input, hidesheet 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
Various Styles of List Boxes andCombo Boxes
List Box w/o scroll Dropdown ComboBoxSimple ComboBox Dropdown ListBox List Box w scrollList Box w scroll •ListBox control– Choose an item, with/without scroll bars (VBA automaticallyadds scrollbar) •ComboBox control
- List may allow for user to add new items– List may "drop down" to display items in list User can type text User cannot type text
ListBox
Properties
Name: lstStates
Text
ListFillRange
Events
Code:
lstNames.AddItem (txtName.Text)
ComboBox
Style
DropDownCombo
DropDownList
Forms
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?
