Excel Macros & VBA

Training

In London

£ 375 + VAT

Description

  • Type

    Training

  • Location

    London

  • Duration

    2 Days

To give users an understanding of macros and visual basic. Knowledge gained from the problem solving and error trapping exercises will enable delegates to code programmes within the Excel application. Suitable for: This course is suitable for users of Excel who want to gain a good knowledge of VBA and Macros.

Facilities

Location

Start date

London
See map
100a Chalk Farm Road, NW1 8EH

Start date

On request

About this course

An advanced knowledge of Excel is required, gained either by previous experience or attendance on the Excel Advanced/Expert course

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Excel Macros (VBA)

Objective: To give users an understanding of macros and visual basic. Knowledge gained from the problem solving and error trapping exercises will enable delegates to code programmes within the Excel application.

Delegates: Maximum 8
This course is suitable for users of Excel who want to gain a good knowledge of VBA. An advanced knowledge of Excel is required, gained either by previous experience or attendance on the Excel advanced course

Delegate numbers are restricted to 8, to ensure personal attention from the trainer

Structure: PC for every delegate
All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.

Duration: 2 days 9.30 am – 4.30 pm

Course Content:

Understanding Macros
Storing Macros
This Workbook
Personal Macro Workbook
New Workbook

Recording a Basic Macro
To record a macro
Relative References
To set the reference type

Running a Macro

To run a macro automatically when you open a file
Invoking Macros
Macros can be invoked (run) from a number places:
To run a macro from the keyboard
To run a macro from the menu

Editing and Deleting Macros

To edit a macro
To delete a macro

Assigning a Macro to a Toolbar or Menu
To assign a macro to a menu or toolbar

Button Image Editor
To edit a button image
To display the button image

Macro Virus Protection
To change the security levels

The Visual Basic Editor Window

Visual Basic Editor layout
Standard toolbar
Object box
Procedure box
Project explorer
Properties window

The Visual Basic Editor

Procedures
Function procedures
Object oriented programming (OOP)
Objects
Properties
Methods
Variables
Data types
List of data types
Expressions
Operators
Constants
Functions
Arguments

Declaring Variables
Dim statement
Private statement
Public statement
Static statement
Option explicit

Working with Objects
Property values
Visual Basic properties
Returning a property value
Object methods
Other common methods
Using operators in expressions
Concatenation (&)
Logical operators
The is operator
The like operator
User defined functions
User interaction dialogue boxes
InputBox function
MsgBox statement
Program flow commands
Decision making commands
Repeat (looping) commands

  • The If… Then

  • The If…Then… Else… End If structure

  • The nested If structure

  • The select case… End select structure

  • The Do… While loop

  • The Do… Until loop

  • The For… Next loop

  • Handling run time errors

  • User forms (custom dialogue boxes)

  • Adding controls to a custom dialogue box

  • Practical usage of Macros

    STAGE 1 setting up the spreadsheet
    STAGE 2 setting up the input area
    STAGE 3 writing the macro to accept data entry
    STAGE 4 Transferring the input to the spreadsheet
    STAGE 5 Error Trapping

    Dealing with dates
    Dialogue boxes

    Price: £375 + VAT per delegate

Additional information

Support: Pass training will help pay for individuals booking alone, or people on income support or other similar benefits. Discounts are also available to companies.
Payment options: All Courses can be held privately at our premises or otherwise.

Excel Macros & VBA

£ 375 + VAT