Test 2 Flashcards
Module
a set of actions run continuously when certain criteria are met (aka macro)
1st step to creating a userform
insert->userform
Application.OnTime
Use when you want to schedule some activity of the program at a certain time, eg. runs “showtime” every second
Userform
Triggers events by controls
Format for Do Until
Do Until [Jump out Condition]…Loop
Major functions needed in time related interface design (3)
- how to display real time dynamically
- Time adjustment - how to stop displaying the real time in order to adjust the time
- Alarm function - how to play sound
Timer vs. time vs. timevalue
timer; cannot keep time of system, time can, timevalue are arbitrary time values added or subtracted from time
VBA
a graphical programming tool
Place that defines what the button says
“Caption”
Coding skills for production systems
Simulation of production systems, healthcare systems
Place that defines the code name for the button
“Name”
How to turn on VBA
File->Options->customize ribbon
Steps to creating “adjust time” module
(1) create userform and 3 labels
(2) declare variables and adjhour
(3) code the module
(4) code the userform
Coding languages in operations research
MATLAB, CPLEX
Where to display time in VBA
- Toolbox -> Label (Label.caption)
- Toolbox -> TextBox (TextBox.text)
Saving VBA
A macro-enabled workbook