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
English [Auto-generated]
Current price: $10 Original price: $75 Discount: 87% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • A copy of Microsoft Excel 2007, 2010, 2013 or 2016 can be used to follow along with this course.
Description

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
03:16:19
+
Quick Course Introduction
2 Lectures 03:04

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



Project #1 - Exercise - Adding Controls to the UserForm
00:23

Project #1 - Working with the Control's Properties
04:40

Project #1 - Exercise - Working with UserForm Control Properties
01:05

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

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

Project #1 - Control Default Value
03:14

Project #1 - Call Start and End Time Buttons
04:04

Project #1 - Displaying the Excel VBA UserForm to the User
06:26

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
05:03

Project #2 - Transfer Data from UserForm to Worksheet List
09:10

Project #2 - Calculating Data in VBA
04:18

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

Project #2 - Exercise - Working with Excel VBA ARRAYS
00:50

Project #2 - Call Generate Call ID Procedure from UserForm
07:42

Project #2 - Vaildating Data Entry in the UserForm
05:35

Project #2 - Clearing the Form
09:49

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

Project #3 - Creating the Print Report Excel VBA UserForm
04:36

Project #3 - Exercise - Setting Properties of the UserForm Controls
00:27

Project #3 - Creating a New Excel Workbook with VBA
04:25

Project 3 - Loop Through all Worksheets in Workbook
09:41

Project #3 - Pasting Data into a New Excel Workbook
09:58

Project #3 - A Little Clean Up with VBA
05:31

Project #3 - Exercise - Close Button VBA
00:28

Project #3 - Exercise - Creating the Print Report Button
00:23

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

Project #4 - Exercise - Build Call Stats Excel UserForm
00:16

Project #4 - Exercise - Setting Properties of UserForm Call Stats
00:56

Project #4 - Create Temporary Stats Worksheet
10:11

Project #4 - Create Temp Sheet Continued
10:13

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

Project #4 - Initialize Call Stats UserForm
06:04

Project #4 - Exercise - Refresh and Close Buttons
00:39

Project #4 - Email Stats with VBA and Outlook
08:10

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

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

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;

  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""

      • "ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."

      • "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!