Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
Overview
In This Chapter
This chapter covers 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
-
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. This object model enables you to write VBA code that adds or removes modules, generates other VBA code, or even creates UserForms on the fly.