Type Property
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Type property as it applies to the CommandBar object.
command bar
MsoBarType can be one of these MsoBarType constants. |
msoBarTypeMenuBar |
msoBarTypeNormal |
msoBarTypePopup |
expression.Type
expression Required. An expression that returns a CommandBar object.
Type property as it applies to the CommandBarButton, CommandBarComboBox, CommandBarControl, and CommandBarPopup objects.
MsoControlType
MsoControlType can be one of these MsoControlType constants. |
msoControlActiveX |
msoControlAutoCompleteCombo |
msoControlButton |
msoControlButtonDropdown |
msoControlButtonPopup |
msoControlComboBox |
msoControlCustom |
msoControlDropdown |
msoControlEdit |
msoControlExpandingGrid |
msoControlGauge |
msoControlGenericDropdown |
msoControlGraphicCombo |
msoControlGraphicDropdown |
msoControlGraphicPopup |
msoControlGrid |
msoControlLabel |
msoControlLabelEx |
msoControlOCXDropdown |
msoControlPane |
msoControlPopup |
msoControlSpinner |
msoControlSplitButtonMRUPopup |
msoControlSplitButtonPopup |
msoControlSplitDropdown |
msoControlSplitExpandingGrid |
msoControlWorkPane |
expression.Type
expression Required. An expression that returns one of the above objects.
Type property as it applies to the SearchScope object.
MsoSearchIn
MsoSearchIn can be one of these MsoSearchIn constants. |
msoSearchInCustom |
msoSearchInMyComputer |
msoSearchInMyNetworkPlaces |
msoSearchInOutlook |
expression.Type
expression Required. An expression that returns a SearchScope object.
Type property as it applies to the DocumentProperty object.
Returns or sets the document property type. Read-only for built-in document properties; read/write for custom document properties.
expression.Type
expression Required. An expression that returns a DocumentProperty object.
Remarks
MsoDocProperties
MsoDocProperties can be one of these MsoDocProperties constants. |
msoPropertyTypeBoolean |
msoPropertyTypeDate |
msoPropertyTypeFloat |
msoPropertyTypeNumber |
msoPropertyTypeString |
Example
As it applies to the CommandBar object.
This example finds the first control on the command bar named Custom. Using the Type property, the example determines whether the control is a button. If the control is a button, the example copies the face of the Copy button (on the Standard toolbar) and then pastes it onto the control.
Set oldCtrl = CommandBars("Custom").Controls(1)
If oldCtrl.Type = msoControlButton Then
Set newCtrl = CommandBars.FindControl(Type:= _
MsoControlButton, ID:= _
CommandBars("Standard").Controls("Copy").ID)
NewCtrl.CopyFace
OldCtrl.PasteFace
End If
As it applies to the DocumentProperty object
This example displays the name, type, and value of a document property. You must pass a valid DocumentProperty object to the procedure.
Sub DisplayPropertyInfo(dp As DocumentProperty)
MsgBox "value = " & dp.Value & Chr(13) & _
"type = " & dp.Type & Chr(13) & _
"name = " & dp.Name
End Sub