Excel VBA

Course

In Glasgow and Edinburgh

£ 550 + VAT

Description

  • Duration

    2 Days

Description

Use VBA terminology, start Visual Basic Editor, and work with object properties, methods, and events. Manipulate data by declaring variables and procedures of correct scope to be used when and where you need them. Use decision structures to perform decision tasks and loop structures to perform repetitive tasks. Add a user form to your project, add controls on it, handle events associate with form.
Suitable for: This course teaches experienced Excel users about the greater advantages to be gained by combining the built-in features of Excel with the programming capabilities of Visual Basic for Applications (VBA). The course is designed to give delegates a thorough overview of programming within the Excel environment, enabling them to improve the functionality of their Excel spreadsheets.

Facilities

Location

Starts

Edinburgh (Midlothian/Edinburghshire)
See map
16 St. Mary Street, EH1 1SU

Starts

On request
Glasgow
See map
Graham Hills Building, 50 Richmond Street, G1 1XP

Starts

On request

To take into account

This is a generic course and is suitable for users of any version of Microsoft Excel. This course is particularly beneficial for those with a sound knowledge of Excel who are familiar with other features available such validation, protection & security, advanced formatting, formulae & functions.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Course programme

Excel VBA

Visual Basic For Applications Overview

  • The VBA Editor
  • Program Structure
  • Customising The VBA environment

Recording and Running Procedures

  • Naming and Recording Procedures
  • Controlling Reference Type
  • Assigning Procedures

Viewing and Editing Procedures

  • Reading Visual Basic Code
  • Editing Visual Basic Code
  • VBA Project Properties

Working with Visual Basic Code

  • Variables
  • Sub Procedures
  • User Defined Functions

Objects, Properties and Collections

  • Controlling Objects using Properties
  • Performing actions with Methods
  • Object Collections and Variables

User Input, Control and Looping

  • User Input
  • Control Structures
  • Looping

Debugging and Error Handling

  • Compile Errors
  • Run-time Errors
  • Logical Errors Debugging Code

Customising the User Interface

  • Worksheet Forms
  • Custom Dialog Boxes

Excel VBA

£ 550 + VAT