side bar:  IT Training, computer training in Scotland, Edinburgh iTrain Scotland Logo:  Phone us on 07711 341 320. Superior computer training for microsoft word, excel, access, office 97, office 2000, office xp, macromedia dreamweaver, fireworks, web design side bar:  IT Training, computer training in Scotland, Edinburgh
Go Back to courses
Microsoft Excel VBA: 2 day course outline

Overview & Prerequisite

This course is designed for advanced users of Microsoft Excel who are looking to develop macros and learn how to code with VBA.

Course content

Introduction to Macros

  • What is a Macro? • Recording a Macro • Running a Macro • Relative References • Assigning a Macro to a Button on a Worksheet • Assigning a Macro to a Button on a Toolbar • Button Image Editor

Editing Macros

  • The Visual Basic Editor • The Project Explorer • The Code Window • Procedures • Inserting Comments • Printing a Visual Basic Module

The Range Object

  • What is the Range Object? • The Cells Property • The Range Property • Flexible Ranges • Range Contents

Workbooks and Sheets

  • Activating a Workbook • Activating a Worksheet • ThisWorkBook

Objects, Properties and Methods

  • Controlling Objects with their Properties • Performing Actions with Methods • Performing Multiple Actions on an Object

Variables and Constants Control Structures

  • Conditional Control Structures • Looping Control Structures • Non-Structured Statements • Subprocedures

Controls, Dialogue Boxes and Forms

  • Built-In Dialogue Boxes • Predefined Dialogue Boxes • Custom Forms • Worksheet Forms • Setting the Properties of a Control • User-Defined Forms • Adding Form Controls • Form Control Properties • Control and Dialogue Box Events • Displaying and Dismissing a User Form • Handling Form Controls

Toolbars and Display

  • About Toolbars and Menus • Attaching Toolbars to Workbooks • Saving More Than One Toolbar Configuration • Customising Toolbars • Display Techniques

Debugging and Error Trapping

  • What are Errors? • Types of Error • Break Mode • Instant Watch • Stepping Through Code • Error Handling Worksheet and Workbook Events

Function Procedures

  • Function Procedures • User-Defined Functions • Function Wizard • Excel Functions

Add-in Applications

  • What is an Add-in? • Creating an Add-In • Converting an Add-In to a Workbook

 

 

| home | why choose us | courses | contact us | site map |
2000-2003 iTrain Scotland - Site Last Updated: 28 September, 2006 1:12 PM - Website problems e-mail: Support