Microsoft Excel Visual Basic (Macros)

Training

In Edinburgh and Glasgow

£ 201-500

Description

  • Duration

    2 Days

  • Start date

    Different dates available

Learn how to program Microsoft Excel using VBA code. 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.

Important information

Documents

  • Microsoft Excel VBA 1 Day Overview.pdf

Government funding available

Facilities

Location

Start date

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

Start date

Different dates availableEnrolment now open
Edinburgh (Midlothian/Edinburghshire)
See map
16 St. Mary'S Street, EH1 1SU

Start date

On request
Glasgow (Glasgow City)
See map
227 Ingram Street, G1 1DA

Start date

Different dates availableEnrolment now open
Glasgow (Glasgow City)
See map
227 Ingram Street, G1 1DA

Start date

On request

About this course

Expert VBA developers deliver this 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

Subjects

  • Excel
  • Programming
  • Visual Basic
  • Microsoft Office
  • Microst
  • Excel Formula
  • Excel Sheet
  • Spreadsheet
  • Visual Basic training
  • Microsoft Excel
  • Microsoft excel training
  • MS Excel

Teachers and trainers (1)

Cameron Foy

Cameron Foy

Training Consultant

As well as capabilities to advanced level in all the Microsoft Office Applications Cameron is very experienced in tailoring bespoke programming courses, for example in VBA, HTML to suit the needs of specific classes. Experience ranges from public scheduled courses to closed corporate training sessions for major financial institutions, public bodies and others.

Course programme

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).

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

Additional information

Use VBA terminology, access the 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 needed. Use decision structures to perform optional tasks and loop structures to perform repetitive tasks. Add a user form to your project, add controls on it, handle events associate with form controls, and validate data entry on forms. Identify errors in code, use the debugging tools, and write error-handling code to trap errors.

Microsoft Excel Visual Basic (Macros)

£ 201-500