Introduction to VBA Using Microsoft Excel
Sponsored links
The objective of this course is to provide you with the knowledge and confidence to write Visual Basic Code in the Excel environment. The course is structured so that the you produce code quickly and are aware of the application’s requirements, limitations and security implications. Emphasis is placed on writing well structured and effective code. This is an intensive course and a basic knowledge of Excel is required.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
This course is taught by a fully certified Microsoft tutor.
THIS COURSE IS TAUGHT 1-2-1 ON DEMAND.
Topics covered:
Visual Basic Editor
Introduction
Security
Creating a Personal Workbook
The Visual Basic Editor
Subroutines
Range Object
The Active Cell
Operators
Variables
Triggering Code to Run
Building Formal Control Structures
Comparison Operators
If .. Then Decision Structures
For loops / Do Loops
Select Case Decision Structures
The Excel Object Model
Objects
Collections
Referring to Objects and Collections in Code
Properties
Methods
Visual Basic Functions
InputBox Function
MsgBox Function
Triggering Code to Run
Using the Menu Bar
Using a Shortcut Key on the Keyboard
Using a Toolbar Icon
Using a ActiveX Control Button
On an Area, Hot Spot, or Graphic Object (Shape)
More about the Macro Window
Write an Excel Add-in
This course includes:
A fresh buffet lunch
Comprehensive course materials
Ongoing support
Free on-site parking
This Training Course is taught in classrooms in the following locations:
Cardiff
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.
