Manipulating Visual Basic Components


This chapter discusses a topic that some readers might find extremely useful: writing Visual Basic for Applications (VBA) code that manipulates components in a VBA project. Read on to discover the following:

♦ An overview of the VBA Integrated Development Environment (IDE) and its object model

♦ Important information for Excel 2002 and Excel 2003 users

♦ How to use VBA to add and remove modules from a project

♦ How to write VBA code that creates more VBA code

♦ How to use VBA to help create UserForms

♦ A useful function that creates a UserForm on-the-fly

The VBA IDE contains an object model that exposes key elements of your VBA projects, including the Visual Basic Editor (VBE) itself. You can write VBA code that adds or removes modules, generates other VBA code, or even creates a UserForm on-the-fly.

0 0

Post a comment