Course Details
Course Outline
1 - Getting Started
Introducing Visual Basic for ApplicationsDisplaying the Developer Tab in the RibbonRecording a MacroSaving a Macro-Enabled WorkbookRunning a MacroEditing a Macro in the Visual Basic EditorUnderstanding the Development EnvironmentUsing Visual Basic HelpClosing the Visual Basic EditorUnderstanding Macro Security
2 - Working with Procedures and Functions
Understanding ModulesCreating a Standard ModuleUnderstanding ProceduresCreating a Sub ProcedureCalling ProceduresUsing the Immediate Window to Call ProceduresCreating a Function ProcedureNaming ProceduresWorking with the Code Editor
3 - Understanding Objects
Understanding ObjectsNavigating the Excel Object HierarchyUnderstanding CollectionsUsing the Object BrowserWorking with PropertiesUsing the With StatementWorking with MethodsCreating an Event Procedure
4 - Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and StatementsDeclaring VariablesUnderstanding Data TypesWorking with Variable ScopeUsing Intrinsic FunctionsUnderstanding ConstantsUsing Intrinsic ConstantsUsing Message BoxesUsing Input BoxesDeclaring and Using Object Variables
5 - Controlling Program Execution
Understanding Control-of-Flow StructuresWorking with Boolean ExpressionsUsing the If...End If Decision StructuresUsing the Select Case...End Select StructureUsing the Do...Loop StructureUsing the For...To...Next StructureUsing the For Each...Next StructureGuidelines for use of Control-of-Flow Structures
6 - Working with Forms and Controls
Understanding UserFormsUsing the ToolboxWorking with UserForm Properties, Events, and MethodsUnderstanding ControlsSetting Control Properties in the Properties WindowWorking with the Label ControlWorking with the Text Box ControlWorking with the Command Button ControlWorking with the Combo Box ControlWorking with the Frame ControlWorking with Option Button ControlsWorking with Control AppearanceSetting the Tab OrderPopulating a ControlAdding Code to ControlsLaunching a Form in Code
7 - Working with the PivotTable Object
Understanding PivotTablesCreating a PivotTable Using Worksheet DataWorking with the PivotTable ObjectsWorking with the PivotFields CollectionAssigning a Macro to the Quick Access Toolbar
8 - Debugging Code
Understanding ErrorsUsing Debugging ToolsSetting BreakpointsStepping through CodeUsing Break Mode during Run modeDetermining the Value of Expressions
9 - Handling Errors
Understanding Error HandlingUnderstanding VBA's Error Trapping OptionsTrapping Errors with the On Error StatementUnderstanding the Err ObjectWriting an Error-Handling RoutineWorking with Inline Error Handling
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
Other Prerequisites
Proficient knowledge of Microsoft Excel. Knowledge of PivotTables
helpful but not required.