Visual Basic for Applications

1
Visual Basic for Applications

• Class III

2
User Forms

• We place controls on User Forms to get input from
  the user.
• Common controls include text boxes, command
  buttons, and check boxes.
• Forms and controls can both trigger events that
  our programs can respond to.

3
Controls
4
Events

• Any action, e.g. clicking a button, opening a
  form, etc. generates an event.
• VBA handles events by sending them to procedures
  named Object_Event.
• Example If click on a button named cmdPressMe
  then VBA will try to run a procedure named
  cmdPressMe_Click

5
Insert UserForm
6
Labels
7
Text Boxes
8
Combo Box
9
Adding Items to Combo Box
10
Command Buttons
11
Adding Code to Buttons
12
RefEdit
13
Example Controls
14
Building a Web Browser
15
Data Table