Trainingwarehouse
  • View Cart
  • Checkout
  • Items Ordered:, Cart Value:


VBA Programming Student Manual Ref: TMVBAPR

Days of training: 5
Prerequisites: Students taking this course should be familiar with personal computers and Microsoft Office 2000.

Introducing the Visual Basic Editor
Using the Visual Basic Editor
Using the Visual Basic Editor in Excel
Using the Visual Basic Editor in Word
Using the Visual Basic Editor in Access

Working with the Object Model
Using the Object Model
Using the Object Model in Excel
Using the Object Model in Word
Using the Object Model in Access

Working with the object variables
Using object variables
Creating and using object variables in Excel
Creating and using object variables in Word
Creating and using object variables in Access

Working with string variables
Using string variables
Using string variables in Excel
Using string variables in Word
Using string variables in Access

Working with date variables
Discussing date variables
Using date variables in Excel
Using date variables in Word
Using date variables in Access

Working with numeric variables
Discussing numeric variables
Using numeric variables in Excel
Using numeric variables in Word
Using numeric variables in Access

Using the selection structure
Discussing the selection structure
Using the selection structure in Excel
Using the selection structure in Word
Using the selection structure in Access

Using the Select Case statement and the MsgBox function
Understanding Select Case statement and MsgBox function
Using the Select Case statement and the MsgBox function in Excel
Using the Select Case statement and the MsgBox function in Word
Using the Select Case statement and the Msgbox function in Access

Working with the repetition structure and the With statement
Understanding the repetition structure and the With statement
Using the repetition structure and the With statement in Excel
Using the repetition structure and the With statement in Word
Using the repetition structure and the With statement in Access

Advanced repetition structure and string functions
Using the string repetition structure and string functions
Using the string repetition structure and string functions in Excel
Using the string repetition structure and string functions in Word
Using the string repetition structure and string functions in Access

Working with built-in dialog boxes and the Office Assistant
Communicating with the user
Using built-in dialog boxes and the Office Assistant in Excel
Using built-in dialog boxes and the Office Assistant in Word
Using the built-in dialog boxes and the Office Assistant in Access

Working with custom dialog boxes
Creating custom dialog boxes
Using custom dialog boxes in Excel
Using custom dialog boxes in Word
Using custom dialog boxes in Access

Working with option button, check box, and list box controls
Discussing the dialog box controls
Using the option button, check box, and list box controls in Excel
Using the option button, check box, and list box controls in Word
Using the option button, check box, and list box

Automation
Understanding the Automation process
Using Automation in Excel
Using Automation in Word
Using Automation in Access

Advanced Automation and error trapping
Discussing Automation and error trapping
Using Automation and error trapping in Excel
Using Automation and error trapping in Word
Using Automation and error trapping in Access

VBA Programming Student Manual 

Price: (4 or fewer items) £39.95 (Excluding VAT at 20%)
Price: (5 to 19 items) £35.96 (Excluding VAT at 20%)
Price: (20 to 49 items) £31.96 (Excluding VAT at 20%)
Price: (50 or more items) £27.97 (Excluding VAT at 20%)

Quantity:  

VBA Programming Instructor Manual Ref: TIVBAPR
 

Price: £40.95 (Excluding VAT at 20%)

Quantity: