Support

Excel 2010 Visual Basic Course for Applications

3 sessions available starting from $1,155.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

Visual Basic for Applications is the integrated programming language used in Excel 2010. In this course we take an in-depth look at this language, and how it is applied to developing programs & automating operations in Excel 2010.

Duration:

3 Days

Audience:

This course had been designed for the non-technical user who needs to design & create applications in Excel 2010.

Prerequisites:

Participants must have a good understanding of Excel spreadsheets in particular working with ranges.

Course Content:

Introduction to VBA

• Why use VBA if I can record macros in Excel?
• Recoding a Simple macro
• Reviewing the code
• Familiarisation with the VBA environment
• Running Code from the VB Editor window
• Getting help on code
• Stepping through a procedure
• Using a Break...

see more

Visual Basic for Applications is the integrated programming language used in Excel 2010. In this course we take an in-depth look at this language, and how it is applied to developing programs & automating operations in Excel 2010.

Duration:

3 Days

Audience:

This course had been designed for the non-technical user who needs to design & create applications in Excel 2010.

Prerequisites:

Participants must have a good understanding of Excel spreadsheets in particular working with ranges.

Course Content:

Introduction to VBA

• Why use VBA if I can record macros in Excel?
• Recoding a Simple macro
• Reviewing the code
• Familiarisation with the VBA environment
• Running Code from the VB Editor window
• Getting help on code
• Stepping through a procedure
• Using a Break point
• Communicating with the User

VBA Terminology

• Modules and procedures
• Components of your code
• Objects, Collections, Properties and methods
• Using the Excel Object model

Data Types, Variables and Operators

• Working with variables and constants
• Using Data types
• Working with operators and expressions
• Implicit and Explicit Declarations
• Variable Scope - Procedural, Modular or Public
• Passing variables by Value
• Passing variables by Reference
• Using Arrays

Workbooks and Worksheets

• Workbook objects and methods
• Creating a new workbook
• Adding and Renaming Sheets
• Saving and Closing a Workbook

Functions

• Mathematical functions
• Date and time functions
• String functions
• Using Excel functions in VBA code

User Defined Function Procedures

• Creating User Defined functions
• Using user-defined functions in a worksheet
• Declaring Multiple arguments in a function
• Creating a Function Library

Loops

• Do Until and Do While loops
• Looping at least once
• For Next Loop
• For Each Loops with collections

Decision Structures

• Using IF to make decisions
• Testing for multiple conditions
• Establishing Flow control
• Branching
• Call other procedures

Working with Names

• Adding Names
• Deleting Names
• Creating Hidden Names
• Checking for the Existence of a Name

Manipulating data

• Working with the Ranges and Selections
• Using the Cells Property to Select a Range
• Using the Offset Property to Refer to a Range
• Using the Columns and Rows Properties
• Using the Union Method to Join Multiple Ranges
• Using the IsEmpty Function
• Using the CurrentRegion Property
• Using the Areas Collection

File management techniques in VBA

• Open and Save files
• Copy, move and delete files
• Changing folders
• Using Excel Open and SaveAs dialog boxes in code

Custom Forms / Dialog boxes

• Creating a user form
• Labels, text boxes, combo boxes and list boxes
• Setting properties for the form and controls
• Assigning data to combo boxes and list boxes
• Option buttons, Groups, checkboxes and buttons
• Creating the event code for controls
• Initialising the form
• Closing the form
• Using RefEdit to allow user interaction

Managing Information with VBA

• Linking Excel to an Access database
• Adding a Record to the Database from Excel
• Retrieving Records from the Database
• Updating an Existing Record

see less

Choose from 3 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,155.00

Notes:

Course Dates: 10-Aug-11 + 18-Aug-11 + 26-Aug-11

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,155.00

Notes:

Course Dates: 21-Sep-11 + 29-Sep-11 + 07-Oct-11

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,155.00

Notes:

Course Dates: 09-Nov-11 + 17-Nov-11 + 25-Nov-11

Type

  • Class / Group Sessions



My Other Listings

Building Better Teams 1 Day Course
Building Better Teams 1 Day Course
2 sessions available starting from $435.00
Microsoft Excel 2003 Course | PivotTables
Microsoft Excel 2003 Course | PivotTables
4 sessions available starting from $350.00
Conducting Performance Reviews Course
Conducting Performance Reviews Course
2 sessions available starting from $870.00

see all listings »


Found In