XlFormControl can be one of these XlFormControl constants. |
xlButtonControl |
xlCheckBox |
xlDropDown |
xlEditBox |
xlGroupBox |
xlLabel |
xlListBox |
xlOptionButton |
xlScrollBar |
xlSpinner |
expression.FormControlType
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
You cannot use this property with ActiveX controls (the Type property for the Shape object must return msoFormControl).
Example
This example clears all the Microsoft Excel check boxes on worksheet one.
For Each s In Worksheets(1).Shapes
If s.Type = msoFormControl Then
If s.FormControlType = xlCheckBox Then _
s.ControlFormat.Value = False
End If
Next