User Forms for Real

• First, start a new worksheet, call it UserFormDemo
  • Make sure you are working in the UserFromDemo space
• Start VB from the Developer tab, Code workgroup.
• On the Insert button, select UserForm
  • 
  • Note I am redoing work, so my form is called UserForm2, don't panic
  • 
• We can drag things into this.
  • The things are generically called "widgets" in GUI terms.
  • Different widgets have different functions.
  • Building forms requires that you learn how to use each.
• A label widget generally is just used to label things.
  • 
  • Drag one over into the form
  • Type in some text.
  • 
  • Modify the text using the properties.
  • 
  • Edit properties using the properies box
• A button or CommandButton in VBA is a button.
  • Add a command button.
  • Add another command button.
  • 
  • Double click on a button and add the following code

  • Private Sub CommandButton1_Click()
        ActiveCell.Value = "African"
        Unload UserForm2
    End Sub
    
    Private Sub CommandButton2_Click()
        ActiveCell.Value = "European"
        Unload UserForm2
    End Sub
    

• Finally, add a subroutine to the module

• Sub Swallow()
      UserForm2.Show
  End Sub