Common Programmatic IDs

Programmatic IDs (progIDs) are used by several methods to create new instances of objects. For example, the following code creates a new checkbox on the active worksheet:

Sub AddCheckBox(  )
    Dim ole As OLEObject
    ' Add new check box.
    Set ole = ActiveSheet.OLEObjects.Add("Forms.CheckBox.1", _
      , , , , , , 60, 60, 100, 20)
    ' Select the check box.
    ole.Object.Value = True
    ' Set its caption
    ole.Object.Caption = "New Check Box"
End Sub

Table A-2 lists common applications and the objects that they provide, along with the progIDs used to create those objects in code.

Table A-2. Common programmatic IDs (continued)

Application

Object

ProgID

ActiveX Controls

CheckBox

Forms.CheckBox.1

 

ComboBox

Forms.ComboBox.1

 

CommandButton

Forms.CommandButton.1

 

Frame

Forms.Frame.1

 

Image

Forms.Image.1

 

Label

Forms.Label.1

 

ListBox

Forms.ListBox.1

 

MultiPage

Forms.MultiPage.1

 

OptionButton

Forms.OptionButton.1

 

ScrollBar

Forms.ScrollBar.1

 

SpinButton

Forms.SpinButton.1

 

TabStrip

Forms.TabStrip.1

 

TextBox

Forms.TextBox.1

 

ToggleButton

Forms.ToggleButton.1

 

Calendar

MSCal.Calendar

Microsoft Access

Application

Access.Application

 

CurrentData

Access.CodeData

  

Access.CurrentData

 

CurrentProject

Access.CodeProject

  

Access.CurrentProject

 

DefaultWebOptions

Access.DefaultWebOptions

Microsoft Excel

Application

Excel.Application

 

Workbook

Excel.AddIn

 

Workbook

Excel.Chart

 

Workbook

Excel.Sheet

Microsoft Graph

Application

MSGraph.Application ...

Get Programming Excel with VBA and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.