Quick Course Introduction
  • Introduction
  • Exercise Files - Download these Files
Project #1 - Building a User Interface with an Excel VBA UserForm
  • Microsoft Excel VBA Project #1 - Introduction
  • Project #1 - Building the Excel VBA UserForm
  • Project #1 - Adding Controls to the Excel UserForm
  • 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
  • Project #1 - QUIZ - Building a User Interface with Excel VBA UserForms Quiz
Project #2 - Connecting the UserForm to a Worksheet for Data Entry
  • Microsoft Excel VBA Project #2 - Introduction
  • 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
Project #3 - Print Call Log Report
  • Microsoft VBA Project #3 - Introduction
  • 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
Project #4 - Current Call Stats (COMING SOON)
  • Microsoft VBA Project #4 - Introduction
  • 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
Congratulations and Bonus
  • Congratulations! You've Completed the Course