Excel 2007, VBA
This class 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, and create user forms.
Audience
The target student for this course should be familiar with Microsoft Office Excel 2007 and creating macros. Students get the most out of this course if their goal is to become proficient in using Visual Basic for Applications (VBA) to create procedures for controlling the behavior and appearance of an Excel worksheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.
Students taking this course should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that students have completed the following course or have equivalent experience:
- Microsoft® Office Excel® 2007: Advanced
Upon successful completion of this course, students will be able to:
- Use the Visual Basic for Applications (VBA) terminology and start Visual Basic Editor (VBE), save workbooks in a macro-enabled file format, work with object properties and methods, attach code to events and buttons, and use the Object Browser to get information about objects.
- Use the variables of relevant data types, manipulate data by using expressions, get input from the user, declare and use variables of correct scope, declare and use procedures of correct scope, create Sub and Function procedures, and call one procedure from another.
- Use decision structures to create procedures that execute code, based on specific conditions, and use loop structures to execute specific code repeatedly.
- Add a user form to your project and add controls to the user form, handle events attached to controls in a user form, and validate the data entry in the controls.
- Identify compile-time, run-time, and logical errors in code, use the debugging tools, and write error-handling code to trap errors.
- CertBlaster preparation and materials also included.
- Unit 1: Visual Basic Editor
- Unit 2: Programming basics
- Unit 3: Control structures
- Unit 4: Custom dialog boxes
- Unit 5: Debugging and error handling
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.