Microsoft Excel Visual Basics for Applications

What Can You Expect?

This course targets learners who require knowledge of Excel’s underlying programming language, with a view to extending the functionality of macros, as well as creating functions and automating complex tasks.

What Is Required From You?

To ensure success, you should have successfully completed all Excel levels or possess the equivalent knowledge.

3 Day Course Content

Day 1

Understand How VB Talks To Excel

• Understand Automation

• Start Microsoft Excel Macros

• Record, Run and Edit A Macro

• Run A Macro From Visual Basic

• Step Through A Macro

Understand the VB Environment

• The Code Window

• The Project Explorer

• The Properties Window

• The Immediate Window

• The Object Browser

Write Visual Basic Statements

• Make Long Statements Easier To Read

• Create, Declare and Assign Variables

• Use Syntax Help In Visual Basic

• Exit Visual Basic Transpose

• Skip Blanks

• Link

Day 2

Work With Excel Objects in Visual Basic

• Collections, Properties, Methods And Events

• Understand And Use Workbooks And Worksheets

• Understand And Define Ranges

• Manipulate Drawing Objects

• Manipulate Charts

• Use Values And Formulas In Ranges

• Understand And Use Relative And Absolute

• Enhancing Recorded Selection

• Simplifying Selection Pairs And Groups

• Manipulate PivotTables

Day 3

Control Visual Basic

• Use Conditional Statements

• If… Then… Else

• Case Statements

Create Loops

• For Each Loops

• For Loops

• Do Loops

Extend Excel and Visual Basic

• Input Boxes

• Message Boxes

Work With Functions

• Using Excel Functions In Visual Basic

• Create Custom Functions

• Add Function Arguments

• Explore Volatile Functions

Developer

• Handle Errors: Ignore, Check For And Trapping Errors

• Launch Macros With Events

• Active X Controls

• Create Custom Forms

• Launch A Form

• Animate Objects

• Package The Application