Skip to content

Files

Latest commit

 

History

History
37 lines (23 loc) · 837 Bytes

Excel.Shape.ControlFormat.md

File metadata and controls

37 lines (23 loc) · 837 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Shape.ControlFormat property (Excel)
vbaxl10.chm636128
vbaxl10.chm636128
Excel.Shape.ControlFormat
e874098f-ea8c-93ff-f746-a0d568bec5b5
05/14/2019
medium

Shape.ControlFormat property (Excel)

Returns a ControlFormat object that contains Microsoft Excel control properties. Read-only.

Syntax

expression.ControlFormat

expression A variable that represents a Shape object.

Example

This example removes the selected item from a list box. If Shapes(2) doesn't represent a list box, this example fails.

Set lbcf = Worksheets(1).Shapes(2).ControlFormat 
lbcf.RemoveItem lbcf.ListIndex

[!includeSupport and feedback]