Excel Programming with VBA

Course

In Cardiff

£ 400 + VAT

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    2 Days

This two day course is designed to provide delegates with the knowledge to manipulate Excel and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful custom desktop solutions.

Facilities

Location

Start date

Cardiff
See map
East Moors Road, CF24 5RR

Start date

On request

About this course

Before attending this course, students must have: Proficient knowledge of Excel 2003 or 2000. Advanced knowledge of PivotTables helpful but not required.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme


Overview
This two day course is designed to provide delegates with the knowledge to manipulate Excel and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful custom desktop solutions.


Examination information

There is no examination associated with this course.


Prerequisites

Before attending this course, students must have:
Proficient knowledge of Excel 2003 or 2000. Advanced knowledge of PivotTables helpful but not required.
Course outline
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

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

Excel Programming with VBA

£ 400 + VAT