Microsoft Excel Course

Sponsored links

Course Outlines

Introduction to Macros
The capabilities of a Macro, Recording a Macro, Where a macro is stored, Stopping the Recorder, Running a Macro, Absolute and Relative Referencing, Adding a Macro to a Menu, Adding a Macro to a Button on a tool bar, Adding a Macro to a Button on a Worksheet

Viewing & Modifying Recorded Macros
Displaying a Macro, Reading the Visual Basic Code, Getting Help in Visual Basic, Printing a Visual Basic Module

Visual Basic Procedures
What is a Procedure? Procedure Arguments, Calling Procedures, Visual Basic Modules, Calling Procedures from other Modules, Calling Procedures from another Workbook

Visual Basic Objects
Introduction to Objects, Using Objects, Properties in Procedures, Performing Actions with Methods, Collections of Objects, Objects as Containers, Referencing Cells

Delivery:
  • Classroom
Regions:
  • South West England
Category:

Further Details

The Object Browser
Using the Object Browser, Learning Objects’ Properties and Methods, Pasting Code into your Module

Declaring Variables
Why Identify Variables and Arguments in Advance, Option Explicit Helping with Errors, Data Types, Data Types within Arguments, Assigning Objects to Variables

Operators, Constants and Scope
Operators, Constants, Scope of Variables and Constants

Decision Making and Looping
Decision Making, If...Then...Else statements, Select Case Statements, Looping, Do...Loop, For...Next Loops, Nested Control Structures, Exiting From a Control Structure

Testing and Correcting Code
The Tools that can Help, Debugging Tools on the Visual Basic Toolbar, Using the Immediate Window in the Debug Window, Using Watch in the Debug Window, Watch Types in the Watch Window, Stepping through your Code

Controls and Dialog Boxes
Using Simple Predefined Dialog Boxes, Getting Information from the User, Displaying Information with the MsgBox Function, Making Customised User Forms, Setting Control Properties, Assigning Code to Controls and User Forms, Displaying a User Form

Creating Automatic Procedures
Creating Automatic Procedures, Setting Automatic Macros for Single Sheets

This Training Course is taught in classrooms in the following locations:
Exeter
Plymouth
Torquay
Truro

Guide Price: -