Introduction
  • Introduction
  • Leaving a Review and Providing me with Feedback
  • Recording Macros vs Writing VBA
  • Understanding Objects in Excel VBA
  • Understanding VBA Syntax and Parts of Speech
  • Understanding VBA Syntax- Exercise
  • Activating the Developer tab
  • Recording a basic Macro
  • Absolute vs Relative Macro recording
Exploring the Visual Basic Environment
  • Introduction to The Visual Basic Environment
  • The Project Explorer
  • The Properties WIndow
  • The Code WIndow
  • Immediate,Locals and Watch Window
  • Dealing with Modules
  • Comments in Excel VBA
The Range Object
  • Introduction and Changing Cell Values
  • Adding a text to a cell
  • Dealing with Named Ranges
  • Value vs Text Property
  • Row and Column properties
  • The Select Method
  • The Count Property
  • The Address Property
  • The Formula Property
  • The Number Format Property
  • The Font Property
  • Exercise- Range object
Understanding the Cells collection object
  • What is the cells object?
  • Using the Cells collection to affect cells positionally within a range
  • Affecting all cells within a sheet
  • Combining Range and cells objects
  • Exercise-Cells collection object
Working with Sheets/Worksheets
  • Selecting Sheets
  • Adding Sheets
  • Sheets vs Worksheets
  • Copying Sheets
  • Moving Sheets
  • Deleting Sheets
  • Exercises-Worksheets
Understanding Variables in Excel VBA
  • Introduction to Variables
  • Variable Data Types
  • Declaring Variables
  • Forcing Variable Declaration
  • Object Variables
  • Calling a procedure from Another Procedure & Variable Scope
  • Public and Private Variables
  • Declaring Constants
  • Exercises-Variables
Dealing with Workbooks
  • Referring to Workbooks-Different ways
  • Closing Workbooks
  • Adding and Saving Workbooks Part 1 - Save method
  • Adding and Saving Workbooks Part 2 - Save as method
  • opening Workbooks
  • Exercise-Dealing with workbooks
Must Know Excel VBA Logic
  • Finding the Last row
  • Finding the Last Column
  • Finding the next row
  • The WITH Statement
  • Comparison operators in Excel VBA
  • IF Statements- Simple IF Statements
  • IF THEN ELSE Structure
  • IF THEN ELSEIF Structure
  • Nested IFs
  • OR - AND logical operators
  • NOT Logical operator
  • If Statement Exercise
  • CASE Statements Part 1 - Single Case Statements
  • CASE Statements Part 2 - Nested Case Statements
  • Case Statements-Exercise
  • GOTO and Labels
Looping in Excel VBA
  • Loops-Introduction
  • FOR NEXT Loop
  • Exit For
  • Exercise - For Next loop
  • FOR EACH Loop - Intro
  • FOR EACH Loops - More examples
  • Exercise - For each loop
  • Do Loop - Introduction
  • Do Loop Example
  • Do Until
  • Do While
  • Do while vs Do until - Movies Example
  • Exit Do Statement
  • Exercise - Do Loop
Interacting with your users
  • The Messagebox - Introduction
  • Messagebox -Inputs
  • Messagebox - Capturing the User's input
  • Adding a new line to your VBA Strings
  • Exercise - Messagebox