EXCEL VBA – Visual Basic, Fundamentals

Versions 2013, 2016, 2019, Office 365, & Online are also available.

Course Outline

Lesson 1 – Excel Macros

• Macro Introductions
• Running Macros
• Macro Examples

Lesson 2 – Visual Basic Editor

• Interface
• Coding Components
• Debugging and Running Code
• Optional Topics

Lesson 3 – Cell Manipulation

• Cell Identification
• Cell manipulation
• Column and row Techniques
• Cell Offse, xlDowns, CurrentRegion, and Address

Lesson 4 – Formatting Techniques

• Formatting
• With Statements

Lesson 5 – Variables

• Variable Structure
• Global Declarations
• VB Arrays

Lesson 6 – “IF” Statements

• If Statements
• Select Case Statements

Lesson 7 – Message and Input Boxes

• MsgBox
• Input Box
• InputBox Method
• User Form

Lesson 8 – Loop Control Structures

• For Loops
• Do Loops
• Do While
• While Wend Loops

Lesson 9- Worksheet and Workbook Manipulation

• Worksheets
• Workbooks

Lesson 10 – Functions

• Excel Functions
• Call – Calls Another Subroutine
• Using Excel Formulas in VB Code
• Run on Open

Lesson 11 – Custom Programming Techniques

• Custom Function Library

Custom Functions

We look forward to your success!!!