Computer Programming with Excel VBA

Introduction
Course Structure and Contents
Why Learn Excel VBA and SQL?
Writing Your First VBA Program: Hello
Computer Programming Fundamentals
Section Intro
What Is a Computer Program
Computer Language Structure and Elements
Main Data Types
Software Applications Architecture
Quiz: Computer Programming Fundamentals
Summary: Computer Programming Fundamentals
VBA: The Building Blocks
Section Intro
Requirements and Setup
Getting Familiar with the VBA Editor
Referencing Excel Cells, Ranges
Referencing Rows Columns Worksheets
The Immediate Window
The Excel Object Model, Collections
Properties, Methods, Events
The Macro Recorder
Applying Objects Formatting
Range Selection, Copy, Paste
Assignment: Employees Table by Region
Assignment Solution: Employees Table by Region
Data Storage
Numeric Variables
Non-Numeric Variables
Working with Excel Objects
Subroutines and Functions
Working with Strings
Working with Dates
Variables Scope and Lifetime
Constants
User Defined Functions
Application Events
Debugging Tools
Quiz: VBA Building Blocks
Section Summary: VBA Building Blocks
VBA: Programming Techniques
Section Intro
Conditional Program Flow
Loops
Assignment: A Dynamic Certificates Generator
Assignment Solution: A Dynamic Certificates Generator
1-D Arrays
2-D Arrays
ParamArray
Application Behavior Control
User Interaction
User Collections
Enumerations
User Defined Types
Data Structures Summary
Error Handling
Assignment: Purchase Orders Enquiary Tool
Assignment Solution: Purchase Orders Enquiary Tool – Part 1
Assignment Solution: Purchase Orders Enquiary Tool – Part 2
Quiz: VBA Programming
Course Summary: Computer Programming with Excel VBA
Previous Lesson
Next Lesson

Requirements and Setup

Computer Programming with Excel VBA Requirements and Setup
Previous Lesson
Back to Course
Next Lesson