Course Introduction
  • Welcome to the Course
  • Course Exercise Files
Microsoft Excel VBA 101
  • What is VBA?
  • Microsoft Excel Object Structure
  • Activate the Excel Developer Tab
  • Intro to the VBA Window
  • Using the Excel VBA Immediate Window to Reference Object
  • Shorthand Object References
  • Introduction to Properties and Methods of Excel Objects
  • Excel VBA 101 Reference Sheet
Working with Excel's Worksheets Object
  • How to Reference an Excel Worksheet
  • Working with the Select Method
  • Changing the Name of a Worksheet
  • Getting the Number of Worksheets Using the Count Property
  • Creating New Worksheets Using the Add Method
  • Printing Worksheets Using the PrintPreview Method
  • Deleting Worksheets in VBA
  • Excel's Worksheets Object Reference Sheet
Working with Excel's Range Object
  • How to Reference a Range
  • Selecting a Range with an Absolute Reference
  • Changing the Value of a Cell Using the Value Property
  • Using the Copy and Paste Methods
  • Reference a Cell on Another Worksheet
  • Excel's Range Object Reference Sheet
Using Relative References in VBA
  • Understanding the Difference between Absolute and Relative References
  • Using the ActiveSheet Object
  • Using the ActiveCell Object
  • Selecting an Unknown Range Using the CurrentRegion Property
  • Using the Offset() Command to Select a Range
Microsoft Excel VBA Modules and Sub Procedures
  • What is a Module?
  • Creating a Sub Procedure
  • Adding Code to the Procedure
  • Running a Sub Procedure
  • Creating a Button to Run a Sub Procedure
  • Calling a Procedure from another Procedure
  • Adding Comments to VBA Code
  • Saving an Excel File that contains VBA Code
The World of VBA Variables
  • Understanding the Purpose of a Variable
  • Declaring Variables in VBA
  • Giving Variables a Value
  • Common Variable Types
  • Using a String Variable
  • Using an Integer Variable
  • Using a Boolean Variable
Excel VBA Control Structures and Loop
  • Introducing Logic into a Procedure Using the IF Statement
  • Using the ElseIf and Else Statements
  • Understanding the Purpose of a Loop
  • VBA Do While Loop
  • VBA For Each... Next Loop
Interacting with the User
  • Displaying a Prompt Using the MsgBox Function
  • Adding Buttons to the MsgBox
  • How to Handle Button Presses
  • Receive User Input Using an InputBox Method
Congratulations!
  • You've Completed the Course