Creating VBA UserForms
4.6 (33 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.
144 students enrolled

Creating VBA UserForms

Effectively Using Excel and Word Macros to Communicate with Users
4.6 (33 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.
144 students enrolled
Created by Allen Wyatt
Last updated 2/2018
English
English
Current price: $29.99 Original price: $49.99 Discount: 40% off
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will be able to create UserForms and craft them to communicate effectively with users of their macros.
Requirements
  • You should have a working knowledge of creating VBA macros in either Excel or Microsoft Word.
Description

When you create macros using Excel or Word, the traditional way to get input from users and share information with users is through the use of input boxes and message boxes. I want to teach you a skill that can take your use of macros to the next level—at least when it comes to user communication. Specifically, I want to show you how to create and use UserForms within your own macros.

Whether you are a Word user or an Excel user, you'll benefit by the great information I have to share with you. This course is designed to show you how to add this great skill to your toolbox of tricks through focused content and hands-on experience. The course is divided into six lessons, each guiding you step-by-step through the learning and application process.

Who this course is for:
  • Those familiar with creating macros who want to take their skillset to a higher level of proficiency.
Course content
Expand 6 lectures 01:20:37
+ Introduction
6 lectures 01:20:37

In this lesson you discover what UserForms are and what they can do for you. Right off the bat you'll see how to create your own UserForms and add controls that accomplish a simple task.

Preview 15:41

In this lesson you discover just about everything you can imagine when it comes to the 14 or 15 powerful controls you can add to your UserForms. You also discover how to change the appearance and behavior of those controls through the use of a wide range of properties that VBA makes available.

Understanding and Using Controls
15:44

This lesson shows you how to utilize the unique Frame control, which can be used as a handy container for other controls, such as option buttons and check boxes. You'll discover the two or three primary reasons that using frames in your UserForms can help both you and your users.

A Special Case: The Frame Control
08:53

In this hands-on lesson you focus, specifically, on working with UserForms and controls within the Excel environments. You discover how you can tie information in UserForm controls to named ranges within an Excel worksheet, providing a great, flexible way to share information in the UserForm.

Coding Controls in Excel
13:51

Excel isn't the only place you can utilize UserForms. In this hands-on lesson you see how UserForms are used within the framework provided by Microsoft Word. Specifically, you see how to gather information from a user and then use that information to modify a Word document.

Coding Controls in Word
12:42

This lesson shows you how to form a tight bond between your macros and your UserForms. You discover a variety of methods for loading and unloading UserForms all from within your existing macros.

Controlling UserForms from a Macro
13:46