Programming in VBA using Excel

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This 3 day program aims to provide a good understanding of programming in Visual Basic for Applications (VBA), especially as it relates to Microsoft Excel.

Course Content
Recorded Macros

· Macro Recorder Overview

· Recording a Simple Macro

· Running a Recorded Macro

· Relative Recording

· Running a Relative Recording

· Viewing the Module

· Modifying a Recorded Macro

Recorder Workshop

· Creating an Application

· Examining the Data

· Recording a Summation Macro

· Recording an Averaging Macro

· Recording the Minimum and Maximum Macros

· Recording the Divisional Macro

· Testing Macros

· Creating 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

The VBA Editor

· Overview of the VBA Editor

· Opening and Closing the Editor

· Working with the Project Explorer

· Working with the Properties Window

· Using the Work Area

· Working with a Code Module

· Running Procedures from the Editor

· Setting Break Points in the Editor

· Stepping through a Procedure
Understanding VBA

· Overview of VBA

· Using the Immediate Window

· Working with Object Collections

· Setting Property Values

· Working with Worksheets

· Using the Object Browser

· Programming with the Object Browser

Procedures

· Procedures Overview

· Creating a Command Procedure

· Making Sense of IntelliSense

· Using the Edit Toolbar

· Commenting Statements

· Indenting Text

· Bookmarking in Procedures

Using Variables

· Variables

· Creating and Using Variables

· Implicit and Explicit Declarations

· The Scope of Variables

· Procedure Level Scoping

· Module Level Scoping

· Public Scoping of Variables

· Passing Variables by Reference

· Passing Variables by Value

· Avoiding Variant Data Types

· Using Arrays

Using Excel Objects

· Overview of the Excel Object Model

· Splitting the Screen

· Using Workbook Objects

· Using Worksheet Objects

· Using Range Objects

· Using Objects in a Procedure

·
Programming Techniques

· Understanding Programming Conventions

· Communicating with a User

· Prompting for User Input

· Using the Input Method

· Using IF to make Decisions

· Testing for Multiple Conditions

· Looping a Fixed Number of Times

· Looping a Specified or Unknown Number of Times

Custom Forms

· Custom Forms Overview

· Creating a Custom Form

· Changing the Form Properties

· Adding Text Boxes

· Moving Controls

· Adding Label Controls

· Changing Text Box Control Properties

· Changing Label Control Properties

· Adding a Combo Box

· Adding Option Buttons

· Adding Command Buttons

· Running/Initialising a Form

· Closing the Form

· Updating the List

· Creating Error Checking Procedures

· Running a Form from a Procedure

Custom Menus

· Creating a New Menu

· Creating a Cascade Menu

· Adding Menu Commands

· Assigning Macros to Menu Commands

· Removing a Menu

Auto Start Macros

· Automatic Execution of Macros

· Programming Automatic Events

· Running Automatic Procedures

· Automatically Starting the Workbook

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Project 2003 Advanced
Project 2003
Publisher 2003
Visio 2003 Professional Advanced
Visio 2003 Professional
Flash MX 2004 Advanced
Flash MX 2004
HTML
HTML/CSS Advanced
Programming in VBA using Access
Programming in VBA Using Word
Visual Basic
Certificate III in Business Administration
Certificate IV in Business Administration
Excel Formulas and Functions
Excel Pivot Tables & Filtering
Access Query and Reports

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.