Excel.Shape.FormControlType.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Shape.FormControlType property (Excel)	vbaxl10.chm636131	vbaxl10.chm636131	Excel.Shape.FormControlType	a0f7d7e2-a5c0-fd71-bced-fe2866fc6d7f	05/14/2019	medium

Shape.FormControlType property (Excel)

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

Syntax

expression.FormControlType

expression A variable that represents a Shape object.

Remarks

You cannot use this property with ActiveX controls (the Type property of 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

[!includeSupport and feedback]