Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

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

Dealing with Difficult Behaviour 1 day Training Course
Dealing with Difficult Behaviour 1 day Training Course
3 sessions available starting from $435.00
Crystal Reports 2008 Introduction Course
Crystal Reports 2008 Introduction Course
1 session available for $1,055.00
Building Better Teams 1 Day Course
Building Better Teams 1 Day Course
2 sessions available starting from $435.00

see all listings »


Found In