TripleState property
Determines whether a user can specify, from the user interface, the Null state for a CheckBox or ToggleButton.
Syntax
object.TripleState [= Boolean ]
The TripleState property syntax has these parts:
| Part | Description |
|---|---|
| object | Required. A valid object. |
| Boolean | Optional. Whether the control supports the Null state. |
Settings
The settings for Boolean are:
| Value | Description |
|---|---|
| True | The button clicks through three states. |
| False | The button only supports True and False (default). |
Remarks
Although the TripleState property exists on the OptionButton, the property is disabled. Regardless of the value of TripleState, you cannot set the control to Null through the user interface.
When the TripleState property is True, a user can choose from the values of Null, True, and False. The null value is displayed as a shaded button.
When TripleState is False, the user can choose either True or False.
A control set to Null does not initiate the Click event.
Regardless of the property setting, the Null value can always be assigned programmatically to a CheckBox or ToggleButton, causing that control to appear shaded.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.