"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com
  • Microsoft/Microsoft Excel Macro/VBA (Part1) Duration: 1 day

Microsoft Excel Macro/VBA (Part1) Duration: 1 Day

Course Overview

This course introduces users to the process of writing and editing Macros. No prior programming experience is assumed. Candidates should have an excellent working Knowledge of Excel or should have attended the Excel L3 training. FURTHER TRAINING: MS Excel MACRO PART 2 1 day course is available which builds on this training (Part1) The course can be run as a 2 day course or as separate 1 day courses.

 

 

This course introduces users to the process of writing and editing Macros. No prior

programming experience is assumed. Candidates should have an excellent working

Knowledge of Excel or should have attended the Excel L3 training.

FURTHER TRAINING: MS Excel MACRO PART 2

1 day course is available which builds on this training (Part1)

The course can be run as a 2 day course or as separate 1 day courses.

Introducing Visual Basic for Applications

  • Configuring Excel’s security and trust settings.
  • Recording a Macro
  • Absolute vs. relative recording modes
  • Running a Macro
  • Automatically executing macros
  • Editing a Macro in the Visual Basic Editor
  • Understanding the Development Environment
  • Using Visual Basic Help

Working with Procedures and Functions

  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Working with the Code Editor

Understanding Objects

  • Understanding Objects
  • Navigating the Excel Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions

  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes
  • Declaring and Using Object Variables

Controlling Program Execution

  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If...End If Decision Structures
  • Using the Select Case...End Select Structure
  • Using the Do...Loop Structure
  • Using the For...Next Structure
  • Using the For Each...Next Structure
  • Guidelines for use of Control-of-Flow Structures

Creating Excel Addins

  • Writing Excel addins
  • Loading addins