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.

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, adds it to the project, and 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.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.