Unit 1: Introducing the Visual Basic Editor
- Understanding the Visual Basic Editor interface
- Working in Visual Basic Editor
- Coding a workbook object's event procedure
- Saving and running a workbook object's event procedure
- Coding the GetGenius macro procedure
- Coding the document object's event procedure
- Saving and running document object's event procedure
- Coding the DisplayDate macro procedure
- Coding the form object's close event procedure
- Saving and running the form object's close event procedure
- Coding the CancelAssistant macro procedure
Unit 2: Working with the Object Model
- Understanding the Object Model
- Getting Help in the Object Browser
- Using the Immediate window
- Using the Object Browser
- Using the Immediate window in Excel
- Referring to range objects
- Using the Object Browser in Word
- Using the Immediate window
- Using the Range object's select method
- Using the Object Browser
- Using the Immediate window in Access
Unit 3: Working with the object variables
- Discussing variables
- Discussing object variables
- Reserving a procedure-level variable
- Using the Set Statement
- Creating the FormatWorksheet macro procedure
- Entering a value and formula into a range object
- Formatting and previewing worksheet objects
- Creating the FormatPromo macro procedure
- Using the ApplyTheme instruction
- Adding a hyperlink to a document
- Creating the DisplayByGrade procedure
- Ordering the records in a report
- Creating the DisplayByGradeMacro macro
Unit 4: Working with string variables
- Reserving a procedure-level string variable
- Discussing an assignment statement
- Discussing the InputBox function
- Concatenating strings
- Discussing the Val function
- Discussing the Option Explicit statement
- Coding the workbook's open event procedure
- Creating a Facsimile Transmittal sheet
- Creating the Fax Transmittal macro procedure
- Creating a custom toolbar and button
- Creating the SelectFieldOrder procedure
- Creating the SelectFieldOrderMacro macro
Unit 5: Working with date variables
- Reserving a procedure-level date variable
- 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
- Creating the CalcHours macro procedure
- Using the Offset property
- Coding the PrintInvitation procedure
- Creating the AssignDates procedure
- Creating a custom toolbar and button
Unit 6: Working with numeric variables
- Reserving a procedure-level numeric variable
- Using an Assignment statement
- Creating a list box
- Coding the List Box's DblClick event procedure
- Using the Excel VLookup function in a procedure
- Coding the UpdateMembership procedure
- Searching a table
- Discussing the ADO Object Model
- Coding the PaymentUpdate procedure
- Using the Recordset Object's Find method
Unit 7: Using the selection structure
- Using the If?Then?Else statement
- Using the nested If?Then?Else statement
- Using the PublishObjects collection
- Coding the Publish Calculator procedure
- Using the TablesOfContents collection
- Coding the CreateToc procedure
- Modifying the PaymentUpdate procedure
|
Unit 8: Using the Select Case statement and the MsgBox function
- Using the Select Case statement
- Using the MsgBox function
- Using Microsoft Query
- Coding the DisplaySales macro procedure
- Coding the GenerateLabels procedure
- Coding the DisplayReport procedure
Unit 9: Working with the repetition structure and the With
statement
- Discussing the For?Next statement
- Discussing the For Each?Next statement
- Discussing the With statement
- Modifying the DisplaySales procedure
- Opening, activating, and closing a document
- Inserting text in a document
- Coding the PrintAndRecordInfo procedure
- Creating the PostScores procedure
Unit 10: Advanced repetition structure and string functions
- Using the Do?Loop statement
- Using the VBA manipulations functions
- Coding the BreakNameApart procedure
- Coding the SortAndRemoveDuplicates procedure
- Coding the LocateInstructor procedure
Unit 11: Working with built-in dialog boxes and the Office
Assistant
- Using the dialogs collection
- Using the Office Assistant
- Coding the SortAndShade procedure
- Displaying the Sort dialog box in Excel
- Assigning the ColorIndex property
- Assigning the Range object's Cells property
- Coding the PrintClientList procedure
- Using the Range object's InsertDatabase method
- Coding the LocateInstructor procedure
- Using the OpenReport method's WhereCondition argument
Unit 12: Working with custom dialog boxes
- Discussing Windows standards
- Setting the tab order and providing keyboard access ontrol
- Adding a form to the project
- Using the Toolbox to add a control to the form
- Sizing, moving, deleting, saving, and restoring a control
- Adding an existing form to a project
- Setting control properties
- Coding the controls' event procedures in the Update Inventory dialog box
- Coding the controls' event procedure in the ClientList dialog box
- Coding the Command button controls
Unit 13: Working with option button, check box, and list box
controls
- Discussing the dialog box controls
- Adding an option button and a list box
- Coding the form's Initialize event
- Using the AddItem method
- Coding the Calculate button's click event procedure
- Coding the CalculateSales macro
- Coding the form's Initialize event
- Coding the Enter button's click event procedure
- Modifying the Locate button's click event procedure
Unit 14: Automation
- Understanding the Automation process
- Coding the IssueCertificate procedure
- Coding the Enter Information button's click event procedure
- Coding the Create Letter button's click event procedure
Unit 15: Advanced Automation and error trapping
- Using the GetObject function
- Intercepting and handling run-time errors
- Using the Resume statement
- Preventing multiple instances of an application
- Modifying the OpenMemo procedure
- Modifying the CreateCertificate procedure
- Create Letter button's click event procedure
- Modifying the cmdCreate control's click event procedure
|