VBA in Excel - Part 1, Thales Training Consultancy

VBA IN EXCEL - PART 1

Duration:

2 days

Price:

£440.00

Locations Available:

Basingstoke
07-08 Aug 08
30-31 Oct 08

Crawley
17-18 Apr 08
12-13 Jun 08
24-25 Jul 08
18-19 Sep 08

Suitable For

VBA in Excel Part 1 is an introduction to programming in Visual Basic within Excel and looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel. Users must be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Delegates must be able to record and run simple macros. Previous programming experience would be an advantage.

Objectives

By the end of the course participants will be able to:·

Create procedures to manipulate data on worksheets·
Automatically run code when events occur, e.g. opening a workbook, pressing a button·
Code user forms for use within workbooks

Related Courses In Our Range·

Excel – Advanced Macros·
VBA in Excel – Part 2

Versions Available

97, 2000,XP and 2003

All courses marked with * are now available in Microsoft Office 2007 in addition to our usual choice of versions

Course Content

The Visual Basic Environment·

Project explorer·
Excel objects·
Modules·
Properties window·
Code window

Code Structure·

Code structure·
Navigating within your code·
Adding comments·
Using WITH ·
Steps to creating a VBA application

Procedures·

Sub procedures·
Event procedures·
Calling procedures

The Excel Data Model·

Workbook commands·
Worksheet commands·
Excel selection methods·
Data manipulation commands

Statements And Functions·

Events and methods·
Statements and functions·
Input boxes·
Message boxes

Debugging·

Using breakpoints·
Stepping through code·
The immediate window·
The watch window·
The locals window

Error handling ·

Error Handling Routines·
Using ERR Variables·
Declaring variables·
Declaring multiple variables·
Variable data types·
Concatenation·
Scope of variables

Constants·

Declaring constants·
Using constants·
Scope of constants

Looping·

Do while loops·
Do until loops·
For next loops

Conditional statements·

IF statement·
SELECT CASE statement·
Comparison statements·
Logical operators

Creating a user form·

Form layout·
The control toolbox·
Naming conventions·
Adding objects·
Naming objects·
Captions·
Displaying the form

Object properties·

Object properties·
Setting properties at design time·
Setting properties at run time

Interconnectivity between the user form and Excel·

Comparing values·
Transferring information·
Running code