|
VBA Programming, Student Manual
|
|
||||||||||||||
| Click here to view available downloads for this course | ||||||||||||||||
|
Duration: One day Description: This ILT Series Microsoft VBA Programming is designed for the beginning programmer to write procedures using the VBA language. Table Of Contents: Unit 1: Introducing the Visual Basic Editor Topic A: Using the Visual Basic Editor Topic B: Using the Visual Basic Editor in Excel Topic C: Using the Visual Basic Editor in Word Topic D: Using the Visual Basic Editor in Access Unit 2: Working with the Object Model Topic A: Using the Object Model Topic B: Using the Object Model in Excel Topic C: Using the Object Model in Word Topic D: Using the Object Model in Access Unit 3: Working with the object variables Topic A: Using object variables Topic B: Creating and using object variables in Excel Topic C: Creating and using object variables in Word Topic D: Creating and using object variables in Access Unit 4: Working with string variables Topic A: Using string variables Topic B: Using string variables in Excel Topic C: Using string variables in Word Topic D: Using string variables in Access Unit 5: Working with date variables Topic A: Discussing date variables Topic B: Using date variables in Excel Topic C: Using date variables in Word Topic D: Using date variables in Access Unit 6: Working with numeric variables Topic A: Discussing numeric variables Topic B: Using numeric variables in Excel Topic C: Using numeric variables in Word Topic D: Using numeric variables in Access Unit 7: Using the selection structure Topic A: Discussing the selection structure Topic B: Using the selection structure in Excel Topic C: Using the selection structure in Word Topic D: Using the selection structure in Access Unit 8: Using the Select Case statement and the MsgBox function Topic A: Understanding Select Case statement and MsgBox function Topic B: Using the Select Case statement and the MsgBox function in Excel Topic C: Using the Select Case statement and the MsgBox function in Word Topic D: Using the Select Case statement and the Msgbox function in Access Unit 9: Working with the repetition structure and the With statement Topic A: Understanding the repetition structure and the With statement Topic B: Using the repetition structure and the With statement in Excel Topic C: Using the repetition structure and the With statement in Word Topic D: Using the repetition structure and the With statement in Access Unit 10: Advanced repetition structure and string functions Topic A: Using the string repetition structure and string functions Topic B: Using the string repetition structure and string functions in Excel Topic C: Using the string repetition structure and string functions in Word Topic D: Using the string repetition structure and string functions in Access Unit 11: Working with built-in dialog boxes and the Office Assistant Topic A: Communicating with the user Topic B: Using built-in dialog boxes and the Office Assistant in Excel Topic C: Using built-in dialog boxes and the Office Assistant in Word Topic D: Using the built-in dialog boxes and the Office Assistant in Access Unit 12: Working with custom dialog boxes Topic A: Creating custom dialog boxes Topic B: Using custom dialog boxes in Excel Topic C: Using the custom dialog boxes in Word Topic D: Using the custom dialog boxes in Access Unit 13: Working with option button, check box, and list box controls Topic A: Discussing the dialog box controls Topic B: Using the option button, check box, and list box controls in Excel Topic C: Using the option button, check box, and list box controls in Word Topic D: Using the option button, check box, and list box controls in Access Unit 14: Automation Topic A: Understanding the Automation process Topic B: Using Automation in Excel Topic C: Using Automation in Word Topic D: Using Automation in Access Unit 15: Advanced Automation and error trapping Topic A: Discussing Automation and error trapping Topic B: Using Automation and error trapping in Excel Topic C: Using Automation and error trapping in Word Topic D: Using Automation and error trapping in Access |
||||||||||||||||





