AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Excel Objects

Courses


Excel Objects

Length: 1    Cost: $425 + GST    Version: Excel

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreMayJunJulAug
Auckland------
28
Hamilton--
06
----
Christchurch--
19
----
Wellington
31
----
11

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


About this Course

Now that you are learning a new language VBA wouldnt it be nice to have something to talk to? Using VBA in Excel can cover anything from getting the machine to perform the repetitive tasks through to creating your own worksheet functions.



Prerequisites

You will need to have completed our VBA Essential Skills course and be comfortable with the concepts covered there or have equivalent experience.

At Course Completion

This course assumes that youre comfortable with the topics covered in the VBA Essential Skills course and are ready to learn how to interact with Excel. Now we learn how to refer to and interact with the things that make up a workbook.

Course Outline


What Is An Object?
Some definitions to start with

Using Objects In Code
How to use these things in VBA

Using Range Objects
Working with cells

For Each Member In a Collection
Working through a collection of objects

Using Object Browser
Leafing through the owners manual

Working With Values In A Range
Getting the numbers from the sheet into the procedure and back again

Copying and Moving Data
Look, no hands

Working with the Chart Object
Create a chart at the click of a button

Working with Events
Start the code automatically

Using Command Bars
Make your own toolbars


 Print this page