NOTE: This module is included in both the "Master of Financial Analysis"
and the "Master of Visual Basic" Courses, but also available here as a
standalone module.
This module is for those curious about the Control Toolbox, or those who need to
get started using ActiveX controls.
ActiveX controls duplicate some of the look and feel of controls from the Forms
toolbar, but require some VBA coding to operate. In this module you will see and
practice setting up the most common controls of the Controls Toolbox.
The features of this module are:
- An explanation of the of Active-X Controls
- Step-by-step instruction: as you navigate, the correct Excel worksheet is displayed or you are instructed to open specific VBA forms and modules
- Paced examples and use cases
- Access to “Help” at all times: extensive help for working with Excel and VBA and dealing with financial and accounting concepts
|