Excel Programming with VBA
Course
In Cardiff
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
Start date
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.
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