Excel with Microsoft Excel VBA User Forms
4.6 (923 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16,824 students enrolled

Excel with Microsoft Excel VBA User Forms

Learn to Create and Program Microsoft Excel VBA User Forms like a Pro
4.6 (923 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16,824 students enrolled
Created by Kyle Pew
Last updated 9/2016
English
English [Auto]
Current price: $51.99 Original price: $74.99 Discount: 31% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 12 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
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 this course is for:
  • 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.
Course content
Expand all 43 lectures 03:16:19
+ Project #1 - Building a User Interface with an Excel VBA UserForm
11 lectures 41:50
Project #1 - Exercise - Adding Controls to the UserForm
00:20
Project #1 - Working with the Control's Properties
04:40
Project #1 - Exercise - Working with UserForm Control Properties
00:35
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:05
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:48
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:25
Project #3 - Creating the Print Report Excel VBA UserForm
04:36
Project #3 - Exercise - Setting Properties of the UserForm Controls
00:24
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:26
Project #3 - Exercise - Creating the Print Report Button
00:21
Project #3 - Quiz
4 questions
+ Project #4 - Current Call Stats (COMING SOON)
10 lectures 52:09
Project #4 - Exercise - Build Call Stats Excel UserForm
00:15
Project #4 - Exercise - Setting Properties of UserForm Call Stats
00:33
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:37
Project #4 - Email Stats with VBA and Outlook
08:10
Project #4 - Exercise - Call Stats Worksheet Button
00:23
+ Congratulations and Bonus
2 lectures 01:46
Congratulations! You've Completed the Course
00:46
BONUS! Check out my other Courses on Udemy
01:00