Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 20 Minute(s)
Language
English
Taught by
Allen Wyatt
Rating
1 views
Course Overview
Effectively Using Excel and Word Macros to Communicate with Users
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.
Course Content
- 1 section(s)
- 6 lecture(s)
- Section 1 Introduction
What You’ll Learn
- Students will be able to create UserForms and craft them to communicate effectively with users of their macros.
Skills covered in this course
Reviews
-
EEnrique Bernal
Great course full of insight, It's a pity that isn't longer. Nonetheless very recommended to those starting with VBA
-
WWendy Baskett
I found this a useful and helpful introduction to what had seemed to be a complicated subject. I feel more confident now to experiment further with including user forms in my own macros.
-
WWolfgang Ehrlich
An excellent lecture, but you should have advanced knowledge in VBA for Excel and Word. This course is, for me, a useful supplement to the other VBA-courses I’ve participated in. I’ve also learned some new methods which can be implemented in my own projects. Compliments for the subtitles of the videos. They are correct. That is not always so in other courses.
-
JJames Reynolds
This was my first udemy course. This was Very clear presentation even for a person who has not worked with VBA for many years. I will use the information in the future.
