in
f
Sign Up for eNews
- First Name
- Last Name
- Email Address
- Nearest Training Location
- Interested In: Microsoft Office Professional Development Adobe Scheduled Courses In-house/Customised Training

Items 0

Total $0.00

Select Courses

Odyssey Training is a national provider of professional, computer and management training and consultancy.

VBA for Microsoft Excel 2010

Upcoming Course Dates
VBA for Microsoft Excel 2010

Duration
2 days (9:00 am – 4:00 pm)
Meals Provided
Lunch and refresments
Print-Friendly
Print this page
Delivery Methods
Public, In-house, Closed Group
Skills Assessment
Take the test

Expected Outcomes

Record macros using the recorder and create an application using the recorder
Create user-defined functions and work with the VBA editor
Understand VBA concepts and features, create procedures and sub routines
Work with variables and Excel objects
Use standard programming techniques and concepts
Create and program custom forms

Prerequisites

Participants will need to have attended the Microsoft Excel Advanced course or a working knowledge of the topics covered including recording Macros in Excel.

Who Should Attend this Course

This course has been developed for people who wish to improve their skills by using Visual Basic for Applications in Excel to increase productivity using automation.

Topics Covered [Click to Show All]

Recorded macros
Macro recorder overview
Recording, modifying and running macro
Relative recording
Running a relative recording
Viewing the module

Recorder WorkShop
Creating a recorded application
Examining the data
Recording summation, averaging,
maximum, minimum and divisional macros
Testing macros
Objects to run macros
Assigning a macro to an object

User-defined functions
Creating and using a user-defined function
Creating another function
Passing multiple arguments
Modifying a function
Creating a function library

Using the VBA editor
Opening and closing the editor
Project explorer, properties window and using the work area
Working with a code module
Procedures from the editor
Set break points in the editor
Step through a procedure

Understanding VBA
Using the immediate window
Working with object collections
Setting property values
Working with worksheets
Programming object browser

Procedures
Creating a command procedure
Making sense of IntelliSense
Commenting statements
Bookmarking in procedures

Using Variables
Creating and using variables
Implicit and explicit declarations
The scope of variables
Procedure and module level scoping
Public scoping of variables
Passing variables by reference and value
Avoiding variant data types
Using arrays

Using Excel Objects
Splitting the screen
Workbook and worksheet objects
Using worksheet and range
Using objects in a procedure

Programming techniques
Programming conventions
Communicating with the user
Prompting for user input
Using the input method
Using IF to make decisions
Multiple condition looping

Creating custom forms
Custom forms overview
Creating and running custom forms
Changing the form properties
Adding text boxes to forms
Moving controls and adding label controls to forms
Changing text box and label properties
Combo box, option, command

Programming custom forms
Forms programming
Initialising and closing the form
Updating the list
Creating error checking procedure
Running a form from a procedure

Custom menus
Creating a new menu and cascade menu
Adding and assigning macros to menu commands
Removing a menu
Custom menus quick reference

Automatic startup
Programming automatic events
Running automatic procedures
Automatically starting the workbook

Computer Training

Microsoft Office 2010

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2010	Microsoft Access 2010 Introduction	Microsoft Access 2010 Intermediate	Microsoft Access 2010 Advanced	VBA for Microsoft Access 2010
Microsoft Excel 2010	Microsoft Excel 2010 Introduction	Microsoft Excel 2010 Intermediate	Microsoft Excel 2010 Advanced	VBA for Microsoft Excel 2010
Office 2010 New Features	Microsoft Office 2010 New Features
Microsoft Outlook 2010	Microsoft Outlook 2010 Introduction		Microsoft Outlook 2010 Advanced
Microsoft Powerpoint 2010	Microsoft PowerPoint 2010 Introduction		Microsoft PowerPoint 2010 Advanced
Microsoft Project 2010	Microsoft Project 2010 Introduction		Microsoft Project 2010 Advanced
Microsoft Visio Professional 2010	Microsoft Visio 2010 Professional Introduction		Microsoft Visio 2010 Professional Advanced
Microsoft Word 2010	Microsoft Word 2010 Introduction	Microsoft Word 2010 Intermediate	Microsoft Word 2010 Advanced	VBA for Microsoft Word 2010
Introduction to Computers	Introduction to Computers

Microsoft Office 2007

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2007	Microsoft Access 2007 Introduction	Microsoft Access 2007 Intermediate	Microsoft Access 2007 Advanced	VBA for Microsoft Access 2007
Microsoft Excel 2007	Microsoft Excel 2007 Introduction	Microsoft Excel 2007 Intermediate	Microsoft Excel 2007 Advanced	VBA for Microsoft Excel 2007
Office 2007 New Features	Microsoft Office 2007 New Features
Microsoft Outlook 2007	Microsoft Outlook 2007 Introduction		Microsoft Outlook 2007 Advanced
Microsoft Powerpoint 2007	Microsoft PowerPoint 2007 Introduction		Microsoft PowerPoint 2007 Advanced
Microsoft Project 2007	Microsoft Project 2007 Introduction		Microsoft Project 2007 Advanced
Microsoft Visio Professional 2007	Microsoft Visio 2007 Introduction		Microsoft Visio 2007 Professional Advanced
Microsoft Word 2007	Microsoft Word 2007 Introduction	Microsoft Word 2007 Intermediate	Microsoft Word 2007 Advanced	VBA for Microsoft Word 2007

Microsoft Office 2003

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2003	Microsoft Access 2003 Introduction	Microsoft Access 2003 Intermediate	Microsoft Access 2003 Advanced	VBA for Microsoft Access 2003
Microsoft Excel 2003	Microsoft Excel 2003 Introduction	Microsoft Excel 2003 Intermediate	Microsoft Excel 2003 Advanced	VBA for Microsoft Excel 2003
Microsoft Outlook 2003	Microsoft Outlook 2003 Introduction		Microsoft Outlook 2003 Advanced
Microsoft Powerpoint 2003	Microsoft PowerPoint 2003 Introduction		Microsoft PowerPoint 2003 Advanced
Microsoft Project 2003	Microsoft Project 2003 Introduction		Microsoft Project 2003 Advanced
Microsoft Visio Professional 2003	Microsoft Visio 2003 Introduction		Microsoft Visio 2003 Advanced
Microsoft Word 2003	Microsoft Word 2003 Introduction	Microsoft Word 2003 Intermediate	Microsoft Word 2003 Advanced	VBA for Microsoft Word 2003

Microsoft Sharepoint 2010

Adobe Publishing and Web

	Introduction	Advanced
Adobe Acrobat 9.0	Adobe Acrobat 9.0 Introduction	Adobe Acrobat 9.0 Advanced
Adobe Acrobat X	Adobe Acrobat X Introduction	Adobe Acrobat X Advanced
Adobe Captivate 5	Adobe Captivate Introduction
Adobe Dreamweaver CS4	Adobe Dreamweaver CS4 Introduction
Adobe Dreamweaver CS5	Adobe Dreamweaver CS5 Introduction
Adobe Illustrator CS4	Adobe Illustrator CS4 Introduction
Adobe Illustrator CS5	Adobe Illustrator CS5 Introduction
Adobe InDesign CS4	Adobe InDesign CS4 Introduction	Adobe InDesign CS4 Advanced
Adobe InDesign CS5	Adobe InDesign CS5 Introduction	Adobe InDesign CS5 Advanced
Adobe Photoshop CS4	Adobe Photoshop CS4 Introduction	Adobe Photoshop CS4 Advanced
Adobe Photoshop CS5	Adobe Photoshop CS5 Introduction	Adobe Photoshop CS5 Advanced

“Course content was great. Great to have additional information and support after the course.” Phillippa – Systems Manager

Copyright
Privacy
Collection Statement

Microsoft Certified Silver Learning Partner Odyssey Training is a national Australian provider of professional, technical and management training and consultancy. We run customised training and scheduled training courses in Brisbane, Cairns, Melbourne, Sydney and Townsville. We have been a major outsource partner for local and national projects across the private and public sectors. Quality Assurance System conforming to AS/NZS ISO 9001:2008 (Certification no. 1075). Odyssey Training is also a signatory to the Government’s Information Technology Conditions v5 (GITC v5) – Q-953.

Training Schedules

Partnering with employers across Australia. Training your people, bringing out their best!

Experience that speaks for itself.

Build your team, your way!

We are an Australian training company, developing Australia’s professionals.

VBA for Microsoft Excel 2010

Upcoming Course Dates VBA for Microsoft Excel 2010

Melbourne

Sydney

Brisbane

Related Courses

Duration

Meals Provided

Print-Friendly

Delivery Methods

Skills Assessment

Expected Outcomes

Prerequisites

Who Should Attend this Course

Topics Covered [Click to Show All]

Training Courses

Upcoming Course Dates
VBA for Microsoft Excel 2010