Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel VBA

Excel with Microsoft Excel VBA User Forms

Learn to Create and Program Microsoft Excel VBA User Forms like a Pro
Rating: 4.6 out of 54.6 (1,166 ratings)
17,713 students
Created by Kyle Pew
Last updated 9/2016
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

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.

Featured review

Jim Taylor
Jim Taylor
13 courses
9 reviews
Rating: 5.0 out of 5a year ago
If this is the same as the first Excel class, then we're good to go!! This class content was what I wanted to learn!! Kyle is an outstanding teacher. I had a typo somewhere in my code, and he took the time to look through it, find it, and pointed me in the right direction. I Highly recommend his courses, GREAT Teacher

Course content

6 sections • 42 lectures • 3h 15m total length

  • Preview02:29
  • Exercise Files - Download these Files
    00:34

  • Preview01:21
  • Preview02:30
  • Preview06:25
  • 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
  • Project #1 - QUIZ - Building a User Interface with Excel VBA UserForms Quiz
    5 questions

  • Preview02: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
    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

  • Preview02:02
  • 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

  • Preview01:34
  • 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! You've Completed the Course
    00:46

Instructor

Kyle Pew
Microsoft Certified Trainer
Kyle Pew
  • 4.6 Instructor Rating
  • 268,868 Reviews
  • 860,101 Students
  • 19 Courses

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;

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013Excel, Word, PowerPoint, Outlook, Access and Visio

SharePoint End-User 2007, 2010, 2013

VBA (Excel and Access)

Adobe SuitePhotoshop, Illustrator, InDesign

Maya (Modeling and Animation)

Unity3d (Game Design)

HTML, CSS and JavaScript

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!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.