Excel with Microsoft Excel VBA User Forms

Learn to Create and Program Microsoft Excel VBA User Forms like a Pro



MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | 463 MB

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.

What are the requirements?
• A copy of Microsoft Excel 2007, 2010, 2013 or 2016 can be used to follow along with this course.

What am I going to get from this course?
• 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

What is the target audience?
• 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.

Curriculum

Section 1: Quick Course Introduction
Lecture 1   Introduction
Lecture 2   Exercise Files - Download these Files

Section 2: Project #1 - Building a User Interface with an Excel VBA UserForm
Lecture 3   Microsoft Excel VBA Project #1 - Introduction
Lecture 4   Project #1 - Building the Excel VBA UserForm
Lecture 5   Project #1 - Adding Controls to the Excel UserForm
Lecture 6   Project #1 - Exercise - Adding Controls to the UserForm
Lecture 7   Project #1 - Working with the Control's Properties
Lecture 8   Project #1 - Exercise - Working with UserForm Control Properties
Lecture 9   Project #1 - Adding Excel VBA Code to the UserForm's Events
Lecture 10   Project #1 - For... Next... Loop Populating a ComboBox
Lecture 11   Project #1 - Control Default Value
Lecture 12   Project #1 - Call Start and End Time Buttons
Lecture 13   Project #1 - Displaying the Excel VBA UserForm to the User
Quiz 1   Project #1 - QUIZ - Building a User Interface with Excel VBA UserForms Quiz

Section 3: Project #2 - Connecting the UserForm to a Worksheet for Data Entry
Lecture 14   Microsoft Excel VBA Project #2 - Introduction
Lecture 15   Project #2 - Select Worksheets Dynamically on Submit
Lecture 16   Project #2 - Transfer Data from UserForm to Worksheet List
Lecture 17   Project #2 - Calculating Data in VBA
Lecture 18   Project #2 - Generate a Unique Call Log Record ID Procedure with VBA
Lecture 19   Project #2 - Exercise - Working with Excel VBA ARRAYS
Lecture 20   Project #2 - Call Generate Call ID Procedure from UserForm
Lecture 21   Project #2 - Vaildating Data Entry in the UserForm
Lecture 22   Project #2 - Clearing the Form
Quiz 2   Project #2 - Quiz

Section 4: Project #3 - Print Call Log Report
Lecture 23   Microsoft VBA Project #3 - Introduction
Lecture 24   Project #3 - Creating the Print Report Excel VBA UserForm
Lecture 25   Project #3 - Exercise - Setting Properties of the UserForm Controls
Lecture 26   Project #3 - Creating a New Excel Workbook with VBA
Lecture 27   Project 3 - Loop Through all Worksheets in Workbook
Lecture 28   Project #3 - Pasting Data into a New Excel Workbook
Lecture 29   Project #3 - A Little Clean Up with VBA
Lecture 30   Project #3 - Exercise - Close Button VBA
Lecture 31   Project #3 - Exercise - Creating the Print Report Button
Quiz 3   Project #3 - Quiz

Section 5: Project #4 - Current Call Stats
Lecture 32   Microsoft VBA Project #4 - Introduction
Lecture 33   Project #4 - Exercise - Build Call Stats Excel UserForm
Lecture 34   Project #4 - Exercise - Setting Properties of UserForm Call Stats
Lecture 35   Project #4 - Create Temporary Stats Worksheet
Lecture 36   Project #4 - Create Temp Sheet Continued
Lecture 37   Project #4 - Calculate Call Stats with VBA on Temporary Worksheet
Lecture 38   Project #4 - Initialize Call Stats UserForm
Lecture 39   Project #4 - Exercise - Refresh and Close Buttons
Lecture 40   Project #4 - Email Stats with VBA and Outlook
Lecture 41   Project #4 - Exercise - Call Stats Worksheet Button

Section 6: Congratulations and Bonus
Lecture 42   Congratulations! You've Completed the Course
Lecture 43   BONUS! Check out my other Courses on Udemy

视频下载：