FormControlType Property

Microsoft Excel Visual Basic

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