Excel.ControlFormat.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ControlFormat object (Excel)	vbaxl10.chm629072	vbaxl10.chm629072	Excel.ControlFormat	fafc6e6b-641c-2179-0789-d86c2718b3c0	03/29/2019	medium

ControlFormat object (Excel)

Contains Microsoft Excel control properties.

Example

Use the ControlFormat property of the Shape object to return a ControlFormat object. The following example sets the fill range for a list box control on worksheet one.

Note

If the shape isn't a control, the ControlFormat property fails; and if the control isn't a list box, the ListFillRange property fails.

Worksheets(1).Shapes(1).ControlFormat.ListFillRange = "A1:A10"

Methods

• AddItem
• List
• RemoveAllItems
• RemoveItem

Properties

• Application
• Creator
• DropDownLines
• Enabled
• LargeChange
• LinkedCell
• ListCount
• ListFillRange
• ListIndex
• LockedText
• Max
• Min
• MultiSelect
• Parent
• PrintObject
• SmallChange
• Value

See also

• Excel Object Model Reference

[!includeSupport and feedback]