|
Duration
3 Days
Principal Topics
Macro Revision
Limitation of Macros
Why use Visual Basic?
Overview of Functions & Subprocedures
Understanding Event Procedures & Modules
The concepts of object based code
The three types of Event - Form, Section & Control
Writing and using a User Defined Function
Passing parameters to a Function
Using Macro commands in Visual Basic
Step Mode
The Immediate Window
Methods and Properties
Controlling program flow
Creating and Declaring Variables
Using the Debug Window
Trapping Run-time errors
Using MsgBox and InputBox
Calling one Procedure from another
RecordSets
Using VB to Call SQL statements
Using VB to control Excel
Using VB to send e-mail
| 
Courses
