Learn Excel VBA UserForms Project #2

Kyle Pew, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Lessons (59m)
    • 1. Excel VBA UserForms Project #2 Intro

      2:19
    • 2. Selecting a Worksheet Dynamically to Submit Data

      5:03
    • 3. Transfer Data from the UserForm to the Worksheet

      9:10
    • 4. Calculate Time with VBA

      4:18
    • 5. Generate a UNique ID with VBA

      15:21
    • 6. Calling a Custom Procedure from the UserForm

      7:42
    • 7. Validate Data Entry in the UserForm

      5:35
    • 8. Clearing the UserForm Data

      9:49

About This Class

Project #2 of the Excel VBA UserForms series will introduce you to the concept of communicating with and Excel Workbook through the Excel VBA UserForm. Some of the key concepts you will learn include;

  • Selecting Excel Worksheets with VBA
  • Transfer Data from the UserForm to an Excel Worksheet
  • Creating Custom Excel VBA Procdures
  • Excel VBA Arrays
  • Validating UserForm Data