Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Join me in this course and become and Excel VBA UserForm champion! See you in the course.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Quick Course Introduction|
Exercise Files - Download these Files
|Section 2: Project #1 - Building a User Interface with an Excel VBA UserForm|
Microsoft Excel VBA Project #1 - IntroductionPreview
Project #1 - Building the Excel VBA UserFormPreview
Project #1 - Adding Controls to the Excel UserFormPreview
Project #1 - Exercise - Adding Controls to the UserForm
Project #1 - Working with the Control's Properties
Project #1 - Exercise - Working with UserForm Control Properties
Project #1 - Adding Excel VBA Code to the UserForm's Events
Project #1 - For... Next... Loop Populating a ComboBox
Project #1 - Control Default Value
Project #1 - Call Start and End Time Buttons
Project #1 - Displaying the Excel VBA UserForm to the User
|Quiz 1||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 - IntroductionPreview
Project #2 - Select Worksheets Dynamically on Submit
Project #2 - Transfer Data from UserForm to Worksheet List
Project #2 - Calculating Data in VBA
Project #2 - Generate a Unique Call Log Record ID Procedure with VBA
Project #2 - Exercise - Working with Excel VBA ARRAYS
Project #2 - Call Generate Call ID Procedure from UserForm
Project #2 - Vaildating Data Entry in the UserForm
Project #2 - Clearing the Form
Project #2 - Quiz
|Section 4: Project #3 - Print Call Log Report|
Microsoft VBA Project #3 - IntroductionPreview
Project #3 - Creating the Print Report Excel VBA UserForm
Project #3 - Exercise - Setting Properties of the UserForm Controls
Project #3 - Creating a New Excel Workbook with VBA
Project 3 - Loop Through all Worksheets in Workbook
Project #3 - Pasting Data into a New Excel Workbook
Project #3 - A Little Clean Up with VBA
Project #3 - Exercise - Close Button VBA
Project #3 - Exercise - Creating the Print Report Button
Project #3 - Quiz
|Section 5: Project #4 - Current Call Stats (COMING SOON)|
Microsoft VBA Project #4 - IntroductionPreview
Project #4 - Exercise - Build Call Stats Excel UserForm
Project #4 - Exercise - Setting Properties of UserForm Call Stats
Project #4 - Create Temporary Stats Worksheet
Project #4 - Create Temp Sheet Continued
Project #4 - Calculate Call Stats with VBA on Temporary Worksheet
Project #4 - Initialize Call Stats UserForm
Project #4 - Exercise - Refresh and Close Buttons
Project #4 - Email Stats with VBA and Outlook
Project #4 - Exercise - Call Stats Worksheet Button
|Section 6: Congratulations and Bonus|
Congratulations! You've Completed the Course
BONUS! Check out my other Courses on Udemy
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;
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:
What Students have said about Kyle:
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.
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!