Creating VBA UserForms
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.
Instructor
![Allen Wyatt](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 84 Reviews
- 325 Students
- 1 Course
Allen Wyatt, an internationally recognized expert in small computer systems, has been working in the computer and publishing industries for over three decades. He has written more than 60 books explaining many different facets of working with computers, as well as numerous magazine articles. He has been publishing free weekly newsletters about Microsoft Word, Excel, and Windows since 1997. Through the written word and online courses, Allen has helped millions of peoples learn how to better use computers.
Besides writing books, articles, and newsletters, Allen has helped educate thousands of individuals through seminars and lectures throughout the United States, as well as throughout Mexico and Costa Rica. His books, which often form the basis of his presentations, have been translated into many languages besides English, including Chinese, Dutch, French, German, Greek, Italian, Japanese, Korean, Polish, Russian, and Spanish.