Microsoft Excel VBA

Course

In Leeds and London

£ 550 + VAT

Description

  • Duration

    2 Days

The skills and knowledge acquired in Microsoft Excel VBA Introduction are sufficient to be able to use and operate the software at an efficient level. Suitable for: Microsoft Excel VBA Introduction is designed for users who are keen to extend their understanding and knowledge of the software.

Facilities

Location

Start date

Leeds (West Yorkshire)
See map
Chancellor Court, 21 The Calls - Leeds, LS2 7EH

Start date

On request
London
See map
38-44 Gillingham Street, SW1V 1HU

Start date

On request

About this course

Microsoft Excel VBA Introduction assumes the delegate has completed the Excel Fundamentals, Excel Intermediate and Excel Advanced courses or has equivalent knowledge.

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

At the completion of Microsoft Excel VBA Introduction you should be able to:

· Create recorded macros in Excel
· Use the macro recorder to create a variety of macros
· Create and work with user-defined functions
· Work with the main components of the VBA Editor window
· Understand the Excel object model and use the Immediate window
· Create command procedures
· Create and use variables
· Write code to manipulate Excel objects
· Use a range of common programming techniques
· Create a custom form complete with controls and event procedures
· Create code to drive a custom form
· Customise the menu system
· Create procedures that start automatically
· Debug Excel VBA

Microsoft Excel VBA

£ 550 + VAT