Excel with Microsoft Excel VBA User Forms

Course Curriculum

Chapter 1: Quick Course Introduction

Lecture 1: Introduction

Lecture 2: Exercise Files – Download these Files

Chapter 2: Project #1 – Building a User Interface with an Excel VBA UserForm

Lecture 1: Microsoft Excel VBA Project #1 – Introduction

Lecture 2: Project #1 – Building the Excel VBA UserForm

Lecture 3: Project #1 – Adding Controls to the Excel UserForm

Lecture 4: Project #1 – Exercise – Adding Controls to the UserForm

Lecture 5: Project #1 – Working with the Control's Properties

Lecture 6: Project #1 – Exercise – Working with UserForm Control Properties

Lecture 7: Project #1 – Adding Excel VBA Code to the UserForm's Events

Lecture 8: Project #1 – For… Next… Loop Populating a ComboBox

Lecture 9: Project #1 – Control Default Value

Lecture 10: Project #1 – Call Start and End Time Buttons

Lecture 11: Project #1 – Displaying the Excel VBA UserForm to the User

Chapter 3: Project #2 – Connecting the UserForm to a Worksheet for Data Entry

Lecture 1: Microsoft Excel VBA Project #2 – Introduction

Lecture 2: Project #2 – Select Worksheets Dynamically on Submit

Lecture 3: Project #2 – Transfer Data from UserForm to Worksheet List

Lecture 4: Project #2 – Calculating Data in VBA

Lecture 5: Project #2 – Generate a Unique Call Log Record ID Procedure with VBA

Lecture 6: Project #2 – Exercise – Working with Excel VBA ARRAYS

Lecture 7: Project #2 – Call Generate Call ID Procedure from UserForm

Lecture 8: Project #2 – Vaildating Data Entry in the UserForm

Lecture 9: Project #2 – Clearing the Form

Chapter 4: Project #3 – Print Call Log Report

Lecture 1: Microsoft VBA Project #3 – Introduction

Lecture 2: Project #3 – Creating the Print Report Excel VBA UserForm

Lecture 3: Project #3 – Exercise – Setting Properties of the UserForm Controls

Lecture 4: Project #3 – Creating a New Excel Workbook with VBA

Lecture 5: Project 3 – Loop Through all Worksheets in Workbook

Lecture 6: Project #3 – Pasting Data into a New Excel Workbook

Lecture 7: Project #3 – A Little Clean Up with VBA

Lecture 8: Project #3 – Exercise – Close Button VBA

Lecture 9: Project #3 – Exercise – Creating the Print Report Button

Chapter 5: Project #4 – Current Call Stats (COMING SOON)

Lecture 1: Microsoft VBA Project #4 – Introduction

Lecture 2: Project #4 – Exercise – Build Call Stats Excel UserForm

Lecture 3: Project #4 – Exercise – Setting Properties of UserForm Call Stats

Lecture 4: Project #4 – Create Temporary Stats Worksheet

Lecture 5: Project #4 – Create Temp Sheet Continued

Lecture 6: Project #4 – Calculate Call Stats with VBA on Temporary Worksheet

Lecture 7: Project #4 – Initialize Call Stats UserForm

Lecture 8: Project #4 – Exercise – Refresh and Close Buttons

Lecture 9: Project #4 – Email Stats with VBA and Outlook

Lecture 10: Project #4 – Exercise – Call Stats Worksheet Button

Chapter 6: Congratulations and Bonus

Lecture 1: Congratulations! You've Completed the Course