Enabled Property

Applies to

BoundObjectFrame Object

FormatCondition Object

Page Object

CheckBox Object

ListBox Object

SubForm Object

ComboBox Object

ObjectFrame Object

TabControl Collection

CommandButton Object

OptionButton Object

TextBox Object

CustomControl Object

OptionGroup Object

ToggleButton Object

You can use the Enabled property to set or return the status of the conditional format in the FormatCondition object. Read/write Boolean.


expression Required. An expression that returns one of the objects in the Applies To list.


The Enabled property setting is a value that indicates whether the conditional format is enabled or disabled. True enables the conditional format. False disables the conditional format. The default is True.

The Enabled property is available only by using Visual Basic for Applications (VBA) code.

When the Enabled property is True, the conditional format can be displayed in the Conditional Formatting dialog box. The Conditional Formatting dialog box is available by clicking Conditional under Font on the Design tab (in Design view) or the Format tab (in Layout view).

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.