Add Method (VBA Add-In Object Model)

           

Adds an object to a collection.

Syntax

object.Add(component)

The Add syntax has these parts:

Part	Description
object	Required. An object expression that evaluates to an object in the Applies To list.
component	Required. For the LinkedWindows collection, an object. For the VBComponents collection, an enumerated constant representing a class module, a form, or a standard module. For the VBProjects collection, an enumerated constant representing a project type.

You can use one of the following constants for the component argument:

Constant	Description
vbext_ct_ClassModule	Adds a class module to the collection.
vbext_ct_MSForm	Adds a form to the collection.
vbext_ct_StdModule	Adds a standard module to the collection.
vbext_pt_StandAlone	Adds a standalone project to the collection.

Remarks

For the LinkedWindows collection, the Add method adds a window to the collection of currently linked windows.

Note   You can add a window that is a pane in one linked window frame to another linked window frame; the window is simply moved from one pane to the other. If the linked window frame that the window was moved from no longer contains any panes, it's destroyed.

Important   Objects, properties, and methods for controlling linked windows, linked window frames, and docked windows are included on the Macintosh for compatibility with code written in Windows. However, these language elements generate run-time errors when run on the Macintosh.

For the VBComponents collection, the Add method creates a new standard component and adds it to the project.

For the VBComponents collection, the Add method returns a VBComponent object. For the LinkedWindows collection, the Add method returns Nothing.

For the VBProjects collection, the Add method returns a VBProject object and adds a project to the VBProjects collection.