Excel Macros & VBA (Day 1 of 2)
Course Prerequisites
Students should have a firm understanding of how Excel works and what it is used for.
Understanding and experience with formulas, functions, and PivotTables within Excel is strongly recommended. No previous experience with Visual Basic for Applications is required. Please ensure you know the topics covered in - Excel Advancing your Knowledge.
Course Overview
This is day 1 in a two day course. This course is intended to help all intermediate to advanced users get up to speed quickly with Visual Basic for Applications. We will cover different features of the Visual Basic Editor interface; show users how to record, edit, debug, and manage macros; and learn about the syntax that VBA uses to create macros.
Developing Macros
- Create a Macro Using the Macro Recorder
- Visual Basic for Applications
- Object-Oriented Programming
- Macros
- Macro Options
- The Macro Recorder
- Personal Macro Workbooks
- How to Create a Macro Using the Macro Recorder
Edit a Macro
- The Visual Basic Editor
- Projects
- Modules
- The Modules Folder
- Objects
- Properties
- Methods
- VBA Comments
- How to Edit a Macro
Debug a Macro
- The Debugging Process
- Debugging Tools
- How to Debug a Macro
Customize the Quick Access Toolbar and Hotkeys
- How to Customize the Quick Access Toolbar and Hotkeys
Set Macro Security
- Digital Certificates
- Digital Signatures
- Macro Security Settings
- How to Set Macro Security
Formatting Worksheets Using Macros
- Insert Text
- The Selection Property
- The Active Sheet Property
- The Name Property
- The Value Property
- Concatenation
- How to Insert Text
Format Text
- How to Format Text
Sort Data
- The Range Object
- The Select Method
- The Current Region Property
- How to Sort Data
Duplicate Data
- Data Types
- Variables
- Variable Naming Rules
- Operators
- The Assignment Operator
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- The For Next Loop
- Do Loops
- The Worksheets Object
- The Count Property
- The Offset Property
- The Copy Method
- The Paste Method
- How to Duplicate Data
Generate a Report
- The Columns Property
- The AutoFit Method
- The Address Property
- The Call Statement
- The Font Property
- The End Property
- How to Generate a Report