Shape.FormControlType Property (Excel)

Returns the Microsoft Excel control type. Read-only XlFormControl.

expression .FormControlType

expression A variable that represents a Shape object.

You cannot use this property with ActiveX controls (the Type property for the Shape object must return msoFormControl).

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

Concepts

Other resources

Show:
© 2015 Microsoft