Olas Software Training and Development | Excel VBA
00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Excel VBA

 

Description

Price €395 per person

Dates

  • Book a place on this course and pay with your credit card.2 March 2017 , 1 Day
  • Book a place on this course and pay with your credit card.21 March 2017 , 1 Day
  • Book a place on this course and pay with your credit card.30 May 2017 , 1 Day
  • Book a place on this course and pay with your credit card.26 July 2017 , 1 Day
  • Book a place on this course and pay with your credit card.13 October 2017 , 1 Day
  • Book a place on this course and pay with your credit card.15 November 2017 , 1 Day

TARGET AUDIENCE

Aimed at experienced Excel users who need to automate repetitive routines in Excel. This course is suitable for personnel who are responsible for building interactive spreadsheets for users.

PREREQUISITES

None

GOALS AND OBJECTIVES

To create macros for repetitive routines in Excel and to understand VBA in order to automate spreadsheets using loops, inbuilt dialog boxes, Excel forms, and programming techniques.

Course Outline
Click here to download course oultline

Overview of the Macro Facility
When to use Macros
Efficient storage of macros

Recording a Macro
Absolute & Relative record facilities

Assigning Macros
To a Button
To a Toolbar

Viewing Recorded Macros

Editing Recorded Macros

VBA Basic concepts

Visual Basic Editor
Code Window
Project Explorer
Properties Window

VBA Language
Objects, Methods, Properties
Declaring Variables
Using Variables
Using Message Boxes and Input Boxes
Building and Using Loops

Creating Menus for easy use

Custom Forms
Textboxes
Labels
Command buttons

Debugging
Stepping through the macro
Inserting Break Points
Adding and managing a Watch

Automatic Procedures
On opening a file
On closing a file

Understanding and using Client
specific project files

Course Summary & Close

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.