Excel Visual Basic

Prerequisites

Excel beginning through advanced.

Course Objectives

• Understand how Visual Basic talks to Excel.
• Use the Macro Recorder.
• Change multiple properties at once.
• Use the Excel Visual Basic Editor.
• Understand comments, statements, and keywords.
• Understand objects, properties, and methods.
• Delete extraneous code.
• Assign a macro to a graphic object.
• Document Visual Basic code.
• Use the Personal Macro Workbook.
• Use logical operators.
• Assign a macro to a custom tool.
• Write a statement to display a built-in dialog box.
• Use the MsgBox Function.
• Create and Manage Buttons.
• Write a Visual Basic Function procedure.

Back to  Course Descriptions