XL97: Problems Using TripleState Property for OptionButton (165495)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q165495 SYMPTOMS
If you view the properties list for an ActiveX OptionButton control, you
will be able to set the TripleState property to either True or False. But,
setting it to either True or False has no effect on the control's behavior.
CAUSE
The TripleState property is available for the OptionButton control, but it
is essentially disabled for the control. Regardless of the setting of the
TripleState property, through the user interface, you cannot set the
OptionButton to a value other than True (selected) or False (not selected).
This behavior is by design of Microsoft Excel.
RESOLUTION
The TripleState property is designed to work with the ActiveX CheckBox
control. If you set the TripleState property of an ActiveX CheckBox control
to True, then you can toggle the value of the CheckBox from True
(selected), to False (cleared) to Null (dimmed).
REFERENCES
For more information about OptionButton Controls, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Add buttons, check
boxes, or other controls to a worksheet" topic.
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbprb kbProgramming KB165495 |
---|
|