Microsoft Excel Macro - VBA Programming

VBA stands for Visual Basic for Applications. It's a programming language that enables you to control just about everything in Excel. You'll learn how to create Macros that can be run from things like a button on a spreadsheet, the Excel Ribbon - in fact, lots of places. Learning Excel VBA will enable you to do a lot more with the software than you can via the normal spreadsheet view.


Visual Basic for Applications (VBA) is the programming interface for Excel. It allows you to automate tasks and even control other applications such as PowerPoint and Access. 


At the end of this course, you will be able to automate your job tasks in Microsoft Excel.

Macros

Record a Simple Macro

Record a Macro

Run a Macro


Understand the VB Editor

Use the Menu Bar

Use the Standard Toolbar

Use the Project Explorer

Use the Properties Window

Understand the Code Window

Understand Code Window Options

Edit Code


Get Help

Use .CHM or .HLP Files

Close the Visual Basic Editor


Work with Objects

Understand the Object Browser

Understand Objects

Understand the Objects Hierarchy

Reference Objects


Understand Collections

Use the Editing Features

Use the Immediate Window

Use the Auto List

Use Auto Quick Info


Work with Variables

Understand Variables

Declare Variables

Understand Data Types

Store Values in Variables

Store Objects in Variables


Create Procedures and Functions

Understand Procedures

Use the Macro Recorder to Create Sub Procedures

Call Procedures from Procedures

Use Intrinsic Functions

Use Message Boxes

Use Input Boxes


Create Functions

Pass Arguments to a Function

Work with Conditional Statements

Understand Conditional Statements

Work with Decision Structures

Work with Loop Structures


Work with Forms and Controls

Understand UserForms

Use the Toolbox

Work with UserForm Properties

Events and Methods

Use the Properties Window

Understand Controls

Work with the Label Control

Work with the Text Box Control

Work with the Command Button Control

Work with the Combo Box Control

Work with the Frame Control

Work with the Option Button Controls


Add Functionality to Forms

Work with Control Appearance

Set the Tab Order

Populate a Control

Add Code to Controls

Launch Forms from Procedures


Use Pivot Tables

Understand Pivot Tables

Create Pivot Tables

Pivot Table Arguments

Add Fields to Pivot Tables


Control Forms

Control Pivot Tables from a Form

Control a Form from a Custom Toolbar


Understand Debugging

Understand Errors

Debug Code

Debug Tools

Use the Locals Window

Use the Watch Window

Use Breakpoints

attending Microsoft Advanced Excel course

Program Details
Duration 3bDays
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom


Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.

Contact