Scribd
Upload
321 views2 pages

VBA Objects Type

The document describes different shape types in the MsoShapeType enumeration and form controls in the XlFormControl enumeration. It lists the value and description of each shape type and form control. It also provides the programmatic identifier used to create each form control using OLE.

Uploaded by

Ramesh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
321 views2 pages

VBA Objects Type

The document describes different shape types in the MsoShapeType enumeration and form controls in the XlFormControl enumeration. It lists the value and description of each shape type and form control. It also provides the programmatic identifier used to create each form control using OLE.

Uploaded by

Ramesh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

MsoShapeType Enumeration XlFormControl Enumeration

MsoShapeType Value Description XlFormControl Value

msoAutoShape 1 AutoShape       xlButtonControl      0


msoCallout 2 Callout xlCheckBox 1
msoChart 3 Chart xlDropDown 2
msoComment 4 Comment xlEditBox 3
msoFreeform 5 Freeform xlGroupBox 4
msoGroup 6 Group xlLabel 5
msoEmbeddedOLEObject 7 Embedded OLE object xlListBox 6
msoFormControl 8 Form control xlOptionButton 7
msoLine 9 Line xlScrollBar 8
msoLinkedOLEObject 10 Linked OLE object xlSpinner 9
msoLinkedPicture 11 Linked picture
msoOLEControlObject 12 OLE control object
msoPicture 13 Picture
msoPlaceholder 14 Placeholder     
msoTextEffect 15 Text effect
msoMedia 16 Media
msoTextBox 17 Text box
msoScriptAnchor 18 Script anchor
msoTable 19 Table
msoCanvas 20 Canvas
msoDiagram 21 Diagram
msoInk 22 Ink
msoInkComment 23 Ink comment
msoIgxGraphic 24 SmartArt graphic
msoShapeTypeMixed -2 Mixed shape type
ntrol Enumeration OLE programmatic identifier

Description Below control is created By using the below ProgID

Button            CheckBox [Link].1                          


Check box ComboBox                          [Link].1
Combo box CommandButton [Link].1           
Text box Frame [Link].1
Group box Image [Link].1
Label Label [Link].1
List box ListBox [Link].1
Option button MultiPage [Link].1
Scroll bar OptionButton [Link].1
Spinner ScrollBar [Link].1
SpinButton [Link].1
TabStrip [Link].1
TextBox [Link].1
ToggleButton [Link].1

You might also like