Excel VBA Programming Course

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Recording Macro

Lecture 1: Setting up environment

Lecture 2: Recording Macro

Lecture 3: Data Types in Excel VBA

Lecture 4: Modules, Variables & Methods Declaration

Lecture 5: Reading recorded macro

Lecture 6: Modifying recorded macro

Lecture 7: Declaring variables

Chapter 3: Life Game

Lecture 1: Section Overview & introduction to algorithm

Lecture 2: Introduction to User Forms

Lecture 3: User Form controls

Lecture 4: User Form logic implementation

Lecture 5: Generate Field 1

Lecture 6: Generate Field 2

Lecture 7: Int positive limit for field generator

Lecture 8: Generate random population

Lecture 9: Generate 1 Life Cycle – read data

Lecture 10: Generate 1 Life Cycle – apply rules

Lecture 11: Generate 1 Life Cycle – count alive neighbours

Lecture 12: Generate 1 Life Cycle – investigate count alive neighbours

Lecture 13: Generate 1 Life Cycle – copy data from memory to excel

Chapter 4: Minesweeper Game

Lecture 1: Section overview & introduction

Lecture 2: Minesweeper UI Creating Game Panel

Lecture 3: Minesweeper UI adding modes and background sheets

Lecture 4: Adding global variables

Lecture 5: Generate Field

Lecture 6: Generate Field investigate recorded macro

Lecture 7: Generate Field – moving generated code

Lecture 8: Generate Field – read size from cells using global variables

Lecture 9: Generate mines 1

Lecture 10: Generate mines 2

Lecture 11: Generate mines 3 – speed up macro

Lecture 12: Calculate number of mines

Lecture 13: Reveal Fields – catching double click event 1

Lecture 14: Reveal Fields – catching double click event 2

Lecture 15: Reveal Fields – count score and win condition

Lecture 16: Reveal Fields – loosing condition

Lecture 17: Populate win-loose information

Lecture 18: Reveal zeros automatically

Lecture 19: Reveal zeros automatically – bug fix

Lecture 20: Right Mouse Button click catch – mark fields

Lecture 21: Right Mouse Button click – glitch clearing reveald field

Lecture 22: Statistics

Lecture 23: Delete Anti Cheat – Challenge

Lecture 24: Anti Cheat Solution

Lecture 25: Loose Won effect

Lecture 26: Hiding sheets – final

Chapter 5: Class Module & OOP

Lecture 1: Section overview & introduction

Lecture 2: OOP & Design Patterns

Lecture 3: Classes in Excel

Lecture 4: Class example, creating class

Lecture 5: Class Example, object creation

Lecture 6: Factory method overview

Lecture 7: Factory method implementation

Chapter 6: Diet Application

Lecture 1: Section overview & introduction

Lecture 2: Ingredient Class construction

Lecture 3: Ingredient Class Factory

Lecture 4: Meal Class construction

Lecture 5: Meal Class Factory

Lecture 6: Daily Meals Class construction

Lecture 7: Daily Meals Factory

Lecture 8: Meal Class Amend construction and Factory

Lecture 9: Weekly Diet Plan Class construction

Lecture 10: Weekly Diet Plan Factory

Lecture 11: Main View

Lecture 12: Ingredients View

Lecture 13: Ingredients View Modify New Buttons

Lecture 14: Meals View

Lecture 15: Meals View adding UI elements through code 1

Lecture 16: Meals View adding UI elements through code 2

Lecture 17: Meals View dynamically added UI element event handling

Lecture 18: Meals View moving ingredient rows

Lecture 19: Meals View Modify Button

Lecture 20: Weekly Diet View 1

Lecture 21: Weekly Diet View 2

Lecture 22: Weekly Diet dynamic UI generation 1

Lecture 23: Weekly Diet dynamic UI generation 2

Lecture 24: Weekly Diet dynamically added UI element event handling

Lecture 25: Weekly Diet Modify New buttons

Lecture 26: Diet Application File structure and storing data

Lecture 27: Ingredient View Adding New Ingredient 1

Lecture 28: Ingredient View Adding New Ingredient 2

Lecture 29: Ingredient View Adding New Ingredient 3

Lecture 30: Ingredient View Populate Ingredients in ComboBox

Lecture 31: Ingredient View load ingredient from ComboBox

Lecture 32: Meals View Adding New Meal 1

Lecture 33: Meals View Adding New Meal 2 – Check if Numeric Value

Lecture 34: Meals View Adding New Meal 3 – Check if Numeric Value in Dynamic elements

Lecture 35: Meals View Adding New Meal 4 – calculate Kcal 1

Lecture 36: Meals View Adding New Meal 5 – calculate Kcal 2

Lecture 37: Meals View Adding New Meal 6 – calculate Kcal 3

Lecture 38: Meals View Adding New Meal 7 – calculate Kcal 4 Dynamic elements

Lecture 39: Meals View Adding New Meal 8 – calculate Kcal 5 Dynamic elements – bug tracking

Lecture 40: Meals View Adding New Meal 9 – Save data 1