This course is designed to help students describe the concepts in and uses of Visual Basic for Applications, record and edit procedures, debug visual basic code, assign procedures to menus, objects and keyboard shortcuts, use function procedures, and objects properties, and methods. In addition, students will learn to use interactive procedures, control procedures, automate procedures, customize menus and command bars.
Course content
- Describe the concepts in and uses of Visual Basic for Applications
- Record and edit basic procedures
- Debug Visual Basic code
- Assign procedures to menus, objects, and keyboard shortcuts
- Use function procedures
- Use objects, properties, and methods
- Use interactive procedures
- Control procedures
- Automate procedures
- Customize menus and command bars
Prerequisite: Excel Mastering II