You are in Home >

Excel 2000 Programming with VBA

Course Code: MTC25

Send A Message

Description and objective: This course is aimed at those Existing Excel 2000 users who wish to gain an understanding of VBA.
Key topics
Getting Started
Introducing Visual Basic for Applications
Recording a Macro
Running a Macro
Understanding the VB Editor
Using the Menu Bar
Using the Standard Toolbar
Using the Project Explorer
Using the Properties Window
Understanding the Code Window
Understanding Code Window Options
Editing Code
Getting Help
Closing the Visual Basic Editor

Introducing Objects
Understanding the Object Browser
Understanding Objects
Understanding the Object Hierarchy
Referencing Objects
Understanding Collections

Using the Editing Features
Using the Immediate Window
Using the Auto List
Using Auto Quick Info

Introducing Variables
Understanding Variables
Declaring Variables
Understanding Data Types
Storing Values in Variables
Storing Objects in Variables

Creating Procedures and Functions
Understanding Procedures
Using the Macro Recorder to Create Sub Procedures
Calling Procedures from Procedures
Using Intrinsic Functions
Using Message Boxes
Using Input Boxes
Creating Functions
Passing Arguments to a Function

Working with Conditional Statements
Understanding Conditional Statements
Working with Decision Structures
Working with Looping Structures

Working with Forms and Controls
Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Using the Properties Window
Understanding Controls
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls

Adding Functionality to Forms
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching Forms from Procedures

Using PivotTables
Understanding PivotTables
Creating PivotTables
PivotTable Arguments
Adding Fields to PivotTables

Controlling Forms
Controlling PivotTables from a Form
Controlling a Form from a Custom Toolbar

Understanding Debugging
Understanding Errors
Debugging Code
Debugging Tools
Using the Locals Window
Using the Watch Window
Using Breakpoints

Contact MTC

Phone	01915153355 When calling be sure to mention Training Pages
Fax	01915153350

Send a Message

Training Pages can send your message straight to the company.

Your name:
Email address
Phone Optional
Subject	Re: Excel 2000 Programming with VBA
Your message Remember to include your postal address if requesting brochures or other material

Categories

•	Information Technology > Applications > Microsoft > Excel