Learn Excel VBA UserForms Project #1 | Kyle Pew | Skillshare

Learn Excel VBA UserForms Project #1

Kyle Pew, Microsoft Certified Trainer

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

    • 2. Creating an Excel VBA UserForm

    • 3. Adding Controls to the Excel VBA UserForm

    • 4. Modfying UserForm Control Properties

    • 5. Working with Excel VBA ComboBoxes

    • 6. More Excel VBA ComboBoxes

    • 7. Setting Default Values of Controls on a UserForm

    • 8. Adding VBA Code to a Button on a UserForm

    • 9. 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.





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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

Report class