Microsoft Excel VBA Programming (Level 4) 2003 2007 2010
Sponsored links
VBA PROGRAMMING IN EXCEL – from Base2
– 2 days
Delegates will be able to make use of the more powerful features of Microsoft Excel through VBA code.
Delegates should be proficient in the use of Microsoft Excel including commands, functions and simple Macros.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
1 Introduction to Macros
• What is a Macro?
• Recording a Macro
• Running a Macro
2 The VBA Editor
• The Visual Basic Editor
• The Project Explorer
• The Code Window
• Procedures
• Comments
3 Variables
• Declaring Variables
• Forcing Declaration
• Arrays
• Scope of Variables
4 The Range Object
• What is the Range Object
• The Cells Property
• The Range Property
• Range Contents
5 Workbooks and Sheets
• Activating a Workbook
• Activating a Worksheet
• This Workbook
6 Objects, Properties and Methods
• Controlling objects with Properties
• Performing Actions with Methods
• Performing Multiple Actions on an Object
7 Programming Control Structures
• Conditional Control Structures
• Looping Control Structures
• Non-Structured Statements
• Sub Procedures
8 Function Procedures
• Function Procedures
• User Defined Functions
• Function Wizard
• Excel Functions
9 Controls, Dialog Boxes & Forms
• Dialog Boxes
• Custom Forms
• Setting Properties of a Control
• Adding Controls
• Control and Dialog box Events
10 Debugging and Error Trapping
• Types of Error
• Break Mode
• Instant Watch
• Stepping Through Code
• Error Handling
11 Responding to Events
• Where should the code go
• Workbook Events Handlers
• Worksheet Event Handlers
This Training Course is taught in classrooms in the following locations:
Newcastle
Sunderland
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
