Learn Excel VBA UserForms Project #2

Kyle Pew, Microsoft Certified Trainer

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

    • Selecting a Worksheet Dynamically to Submit Data

    • Transfer Data from the UserForm to the Worksheet

    • Calculate Time with VBA

    • Generate a UNique ID with VBA

    • Calling a Custom Procedure from the UserForm

    • Validate Data Entry in the UserForm

    • Clearing the UserForm Data


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

5 of 5 students recommendSee All

Even if you are not going to be creating a form, there are some really good VBA commands in this class that can be adapted for a multitude of projects.
Nice explanation





Kyle Pew

Microsoft Certified Trainer


Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013 Excel, Word, PowerPoint, Outlook, Access and Visio SharePoint End-User 2007, 2010, 2013 VBA (Excel and Access) Adobe Suite Photoshop, Illustrator, InDesign Maya (Modeling and Animation) Unity3d (Game Desig...

See full profile