Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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

      2:19
    • Selecting a Worksheet Dynamically to Submit Data

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

      9:10
    • Calculate Time with VBA

      4:18
    • Generate a UNique ID with VBA

      15:21
    • Calling a Custom Procedure from the UserForm

      7:42
    • Validate Data Entry in the UserForm

      5:35
    • 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

72

Students

--

Projects

Kyle Pew

Microsoft Certified Trainer

Qualifications:

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