Excel VBA (Visual Basic)

Visual Basic for Excel 365 Fundamentals – Excel VBA

Visual Basic for Excel 365 Fundamentals – Excel VBA. Versions 2013, 2016, 2019, Office 365, & Online are also available.

Are you facing a repetitive clean-up of fifty tables in Excel? Do you want a particular document to prompt the user for input when it opens? Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?

You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.

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 – simple, virtuals

• simple, virtual Structure
• Global Declarations
• VB Arrays for Excel VBA

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