Excel with Microsoft Excel VBA User Forms

Learn to Create and Program Microsoft Excel VBA User Forms like a Pro
4.8 (23 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.
690 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 43
  • Length 3.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2016 English

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.

What are the requirements?

  • A copy of Microsoft Excel 2007, 2010, 2013 or 2016 can be used to follow along with this course.

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Quick Course Introduction
Introduction
Preview
02:29
Exercise Files - Download these Files
Article
Section 2: Project #1 - Building a User Interface with an Excel VBA UserForm
Microsoft Excel VBA Project #1 - Introduction
Preview
01:21
Project #1 - Building the Excel VBA UserForm
Preview
02:30
Project #1 - Adding Controls to the Excel UserForm
Preview
06:25
Project #1 - Exercise - Adding Controls to the UserForm
Article
Project #1 - Working with the Control's Properties
04:40
Project #1 - Exercise - Working with UserForm Control Properties
Article
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
5 questions

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

Section 3: Project #2 - Connecting the UserForm to a Worksheet for Data Entry
Microsoft Excel VBA Project #2 - Introduction
Preview
02:19
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
Article
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
Section 4: Project #3 - Print Call Log Report
Microsoft VBA Project #3 - Introduction
Preview
02:02
Project #3 - Creating the Print Report Excel VBA UserForm
04:36
Project #3 - Exercise - Setting Properties of the UserForm Controls
Article
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
Article
Project #3 - Exercise - Creating the Print Report Button
Article
Project #3 - Quiz
4 questions
Section 5: Project #4 - Current Call Stats (COMING SOON)
Microsoft VBA Project #4 - Introduction
Preview
01:34
Project #4 - Exercise - Build Call Stats Excel UserForm
Article
Project #4 - Exercise - Setting Properties of UserForm Call Stats
Article
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
Article
Project #4 - Email Stats with VBA and Outlook
08:10
Project #4 - Exercise - Call Stats Worksheet Button
Article
Section 6: Congratulations and Bonus
Congratulations! You've Completed the Course
00:46
BONUS! Check out my other Courses on Udemy
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kyle Pew, Microsoft Certified Trainer - 25,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!

Ready to start learning?
Take This Course