Excel with Microsoft Excel VBA User Forms
4.8 (122 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,188 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel with Microsoft Excel VBA User Forms to your Wishlist.

Add to Wishlist

Excel with Microsoft Excel VBA User Forms

Learn to Create and Program Microsoft Excel VBA User Forms like a Pro
4.8 (122 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,188 students enrolled
Created by Kyle Pew
Last updated 9/2016
English [Auto-generated]
Current price: $10 Original price: $75 Discount: 87% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 12 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
What Will I Learn?
  • Cut out the all the noise of working with large sets of Microsoft Excel Data by tailoring the Excel Users experience and interface
  • Provide a seamless, accessible interface to your Excel users saving time and money
  • Learn to develop interactive Excel interfaces with Excel VBA User Forms
  • Take advantage of the most powerful aspect of Microsoft Excel to streamline your Excel interactions
View Curriculum
  • A copy of Microsoft Excel 2007, 2010, 2013 or 2016 can be used to follow along with this course.

Customize Your Excel Interactions with Excel VBA UserForms

Microsoft Excel is a very powerful tool, but doesn't always provide the most accessible approach to working with your data. Through the use of Excel VBA and Excel VBA UserForms, you'll be able to create a more accessible and efficient environment to work with your specialized data.

By participating in this course on Microsoft Excel VBA UserForms you will journey through a step by step, project based learning experience. Each project you will be introduced to will build upon the previous project. While completing each project from start to completion, you'll build an Excel experience you'll want to re-create for each of your Microsoft Excel projects.

  • Learn key VBA concepts that relate to building Excel VBA UserForm interafces
  • Streamline yours and your users experience working with large Excel data sets
  • Create intuitive Excel interfaces to create reports and provide summarized data based on Excel tables.

Join me in this course and become and Excel VBA UserForm champion! See you in the course.

Who is the target audience?
  • This Microsoft Excel VBA UserForms course is intended for Microsoft Excel users that are new to creating Excel VBA UserForms. No prior programming knowledge necessary to participate in the course.
Compare to Other Excel VBA Courses
Curriculum For This Course
43 Lectures
Quick Course Introduction
2 Lectures 03:04

Exercise Files - Download these Files
Project #1 - Building a User Interface with an Excel VBA UserForm
11 Lectures 42:23

Project #1 - Exercise - Adding Controls to the UserForm

Project #1 - Working with the Control's Properties

Project #1 - Exercise - Working with UserForm Control Properties

Project #1 - Adding Excel VBA Code to the UserForm's Events

Project #1 - For... Next... Loop Populating a ComboBox

Project #1 - Control Default Value

Project #1 - Call Start and End Time Buttons

Project #1 - Displaying the Excel VBA UserForm to the User

Test your knowledge on creating an Excel VBA UserForm through this quiz

Project #1 - QUIZ - Building a User Interface with Excel VBA UserForms Quiz
5 questions
Project #2 - Connecting the UserForm to a Worksheet for Data Entry
9 Lectures 01:00:07

Project #2 - Select Worksheets Dynamically on Submit

Project #2 - Transfer Data from UserForm to Worksheet List

Project #2 - Calculating Data in VBA

Project #2 - Generate a Unique Call Log Record ID Procedure with VBA

Project #2 - Exercise - Working with Excel VBA ARRAYS

Project #2 - Call Generate Call ID Procedure from UserForm

Project #2 - Vaildating Data Entry in the UserForm

Project #2 - Clearing the Form

Project #2 - Quiz
4 questions
Project #3 - Print Call Log Report
9 Lectures 37:31

Project #3 - Creating the Print Report Excel VBA UserForm

Project #3 - Exercise - Setting Properties of the UserForm Controls

Project #3 - Creating a New Excel Workbook with VBA

Project 3 - Loop Through all Worksheets in Workbook

Project #3 - Pasting Data into a New Excel Workbook

Project #3 - A Little Clean Up with VBA

Project #3 - Exercise - Close Button VBA

Project #3 - Exercise - Creating the Print Report Button

Project #3 - Quiz
4 questions
Project #4 - Current Call Stats (COMING SOON)
10 Lectures 52:37

Project #4 - Exercise - Build Call Stats Excel UserForm

Project #4 - Exercise - Setting Properties of UserForm Call Stats

Project #4 - Create Temporary Stats Worksheet

Project #4 - Create Temp Sheet Continued

Project #4 - Calculate Call Stats with VBA on Temporary Worksheet

Project #4 - Initialize Call Stats UserForm

Project #4 - Exercise - Refresh and Close Buttons

Project #4 - Email Stats with VBA and Outlook

Project #4 - Exercise - Call Stats Worksheet Button
Congratulations and Bonus
2 Lectures 01:58
Congratulations! You've Completed the Course

BONUS! Check out my other Courses on Udemy
About the Instructor
Kyle Pew
4.6 Average rating
13,893 Reviews
70,338 Students
16 Courses
Microsoft Certified Trainer - 65,000+ Udemy Students


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!