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.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기