다음을 통해 공유

ControlFormat Object (Excel)

  • 아티클

Contains Microsoft Excel control properties.

Example

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

참고

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"

참고 항목

개념

Excel Object Model Reference

ControlFormat Object Members