Learn Excel VBA UserForms Project #1 Premium class

Kyle Pew, Microsoft Certified Trainer

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

    • Creating an Excel VBA UserForm

    • Adding Controls to the Excel VBA UserForm

    • Modfying UserForm Control Properties

    • Working with Excel VBA ComboBoxes

    • More Excel VBA ComboBoxes

    • Setting Default Values of Controls on a UserForm

    • Adding VBA Code to a Button on a UserForm

    • Creating a VBA Procedure to Display the UserForm


About This Class


Project #1 of the Learn Excel VBA UserForms course will introduce you to the basic concepts of creating and writing code for Excel VBA UserForms. Some of the key Microsoft Excel VBA UserForm concepts you will learn include;

  • Creating a VBA UserForm
  • Working with UserForm Controls
  • Adding Code to VBA UserForms and Controls
  • Displaying the UserForm to the user

Start your journey into Excel VBA UserForms by build a solid foundation in this course. Next steps, look for the my additional Excel VBA UserForms courses to continue your journey.






Reviews (0)

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;

  1. Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
    1. Excel, Word, PowerPoint, Outlook, Access and Visio
  2. SharePoint End-User 2007, 2010, 2013
  3. VBA (Excel and Access)
  4. Adobe Suite
    1. Photoshop, Illustrator, InDesign
  5. Maya (Modeling and Animation)
  6. Unity3d (Game Design)
  7. HTML, CSS and JavaScript
  8. Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Some of the clients Kyle has provided training for include:

  • Brocade
  • Chevron
  • Genentech
  • Facebook
  • Levi Strauss
  • PMI Mortgage Insurance
  • State Fund
  • Bank of the West
  • VISA
  • Walmart
  • and many more...


What Students have said about Kyle:

    • "Kyle was off the chart "GOOD""


    • "Awesome trainer because I'm computer "stupid" and he helped me understand it."

    • "Kyle Pew is very knowledgeable and presented information with exceptional skill."

In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.

Teaching Philosophy:

Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.

In His Spare Time:

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!