VBComponent Properties

Name Returns Description

CodeModule CodeModule Read-only. Returns the CodeModule for the component, used to store its VBA code.

CodeModule CodeModule Read-only. Returns the CodeModule for the component, used to store its VBA code.

Designer

Read-only. Returns the Designer object for the component, which provides access to the design-time graphical elements of the component.

DesignerlD

String

Read-only. Returns an identifier for the Designer, so you know what sort of Designer it is. For example, a User-Form's designer ID is Forms.Form.

DesignerWindow

Window

Read-only. Returns a Window object, representing the Window displaying the Designer. (Shown as a method in the Object Browser, as it opens the Window if not already open.)

HasOpenDesigner

Boolean

Read-only. Identifies if the component's Designer is open.

Name

String

The name of the VBComponent.

Properties

Properties

Read-only. Returns the component's Properties collection, providing access to the items shown in the Property window, and to many of the associated Excel object's properties if the VBComponent represents the code behind an Excel object. See the Property object in this appendix for more information.

Saved

Boolean

Read-only. Returns whether the contents of the VBComponent has changed since the last save. It is analogous to an Excel workbook's Saved property, but applies to each component individually.

Component

Type

Read-only. Returns the type of the component:

Normal module: vbext_ct_StdModule

Class module: vbext_ct_ClassModule

UserForm: vbext_ct_MSForm

Excel object: vbext_ct_Document

All other types: vbext_ct_ActiveXDesigner

+2 -2

Post a comment