Extensive changes have been made to the Microsoft Excel 97 Visual Basic object model to support new and improved features in the application. Many objects, properties, and methods have been replaced. To provide backward compatibility, most of the replaced components have been hidden rather than removed. This means that they don't show up in the Object Browser by default, but old code that uses the hidden components will still work correctly without modification. When you write new code, however, you should use the new objects, properties, and methods.
The major Visual Basic feature changes in Microsoft Excel 97 are listed in the following table.
Feature | Description |
---|---|
Shapes | Replaces the drawing layer (Arc, Oval, Line, and so on) with a consistent and improved object model in all Microsoft Office applications. |
UserForms, ActiveX controls | Provides a consistent and expandable control and dialog box interface in all Microsoft Office applications. |
CommandBars | Provides a consistent and expandable menu and toolbar interface in all Microsoft Office applications. |
For more information, see one of the following topics:
New Properties and Methods (by Object)