Further Details
Macros and Custom Controls
Macros Vs VBA
Absolute and Relative References
Dos’ and Don’ts when recording
Record and Run Macros
Assign to Toolbars and Menus
Drawing, Editing and Formatting Buttons
The Visual Basic Editor
The Visual Basic Interface
The Code Window
Saving and Running a Procedure
Printing a Procedure
Create Event and Macro Procedures
Coding the Open Event Procedure
Working with Object Model
Using the Object Model
Using the Immediate Window
Working with Object Variables
Using Variables
Using Object Variables
Reserving a procedure-level variable
Naming Variables
Use the Set Statement
Working with String Variables
Reserving a procedure-level string variable
The Assignment Statement
The InputBox Function
Concatenating Strings
The Val Function
The Option Explicit Statement
Working with Date Variables
Reserving a procedure-level date variable
Using an Assignment Statement
Assigning a value to a Date Variable
Using VBA’s Date, Time, and Now Functions
Using the Format Function
Using Dates and Times in calculations
Converting Strings to Dates
The OffsetProperty
Working with Numeric Variables
Reserving a procedure-level numeric variable
Using the Assignment Statement
Assigning a numeric expression to a numeric variable
Creating a List Box
Coding the List Box’s DblClick Event Procedure
Using the Excel Vlookup function in a procedure
Using the Selection Structure
Using the If..Then..Else Statement
Nesting the If..Then…Else Statement
Ucase functions
Logical Operators
Using the Select Case Statement and MsgBox Function
The Select Case Statement
Using To and IS in an Expressionlist
The MsgBox Function
Values returned by the MsgBox function
The QueryTables Collection and QueryTables Objects
The SQL Select Statement
Repetition Structure and the With Statement
The For…Next Statement
The With Statement
Do…Loop and VBA string manipulation functions
Working with Built-In Dialog Boxes and the Office Assistant
The Dialogs Collection
Using the Office Assistant
Properties of the Office Assistant
Properties and Methods of the Balloon ObjectWorking with Custom Dialog Boxes
Creating Custom Dialog Boxes
Setting the Tab Order /Keyboard access to a control
Assigning accelerator keys
Using Default and Cancel Properties
Adding a Form
Naming a form
The Toolbox
Using the Toolbox to add a control to the Form
Control Properties
Working with the Option Button, Check Box and List Controls
Option button control
Check Box Control
List Box Control
Using the Automation Process and Error Trapping
Referencing an Automation Server’s object library
Creating an object for manipulation
Manipulating the object used for Automation
Using the GetObject function
Intercepting and handling run-time errors
The On Error statement and the error-handling routine
The Resume Statement
Website: http://www.westlothianit.co.uk
* Stadium House* Livingston Football Stadium * Alderstone Road * Livingston* West Lothian * Scotland* UK *Tel: +44 01506-602676 (Main Reception)* Direct Number: +44 01506-602687* Fax: +44 01506-602782 * Mobile: Debbie 07855-323527*
Mobile: Patricia 07775-773973 * E-Mail: contact@westlothianit.co.uk * VAT Registration No: 828 3352 22*
Guide price
£795 - 3 Days |
