Programming in VBA Using Word

ELECTUS
Adelaide, SA, Australia

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

Course Description:

'' This course aims to provide you with a good understanding of programming in Visual Basic for Applications (VBA), especially as it relates to Microsoft Word 2003.

Course Content
Recorded Macros

· Recording a Simple Macro

· Running a Recorded Macro

· Assigning a Macro to a Toolbar

· Editing a Recorded Macro

VBA Concepts

· Object Oriented and Event Driven

· Overview of Objects and the Object Model

· Properties, Methods and Events

· Projects and Modules

· Procedures

· The Documents Collection Object

The VBA Editor

· Overview of the VBA Editor

· Opening and Closing the Editor

· Working with the Project Explorer

· Working with a Code Module

· Working with the Properties Window

· Running Programs from the VB Editor

· Using VBA Help

Using Variables

· Overview of Variables

· Data Types

· Implicit and Explicit Declaration of Variables

· The Scope of Variables

· Local Variables

· Public Variables

· Passing Variables by Reference

· Passing Variables by Value

· Working with Constants

Functions

· Creating a Function

· Calling a Function

· The InputBox Function

· Arguments

· MsgBox Function

· Nesting Functions


Decision Structures

· Overview of Decision Structures

· Using the IF Statement to make Decisions

· Select Case Statements

Looping Structures

· Overview of Loops

· Do Loops

· For Loops

· Adding an Exit to a Loop

User Forms and Controls

· Overview of User Forms and Controls

· Design-Time and Run-Time

· Creating a New User Form

· The Label Control and the Text Box Control

· Option Buttons and Frames

· List Boxes and Combo Boxes

· Command Buttons

· Running a User Form

· Viewing the User Form Code

Day 3 Workshop Topics:

Putting it all Together

· VBA Programs

· Incorporating a User Form

· Displaying and Hiding a User Form

· Event Procedures

· Internal Events

· Calculations with Data

· Event Handling

· Data Entry

· Forcing the Correct Entry

· Attaching the Program to a Template

· AutoMacros

Working with Text

· The Selection Object

· The Range Object

· Object Variables

· Inserting Text

· Display Text in a Text Box

· The Find Object


...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

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 Excel
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.