Strange Option Button behaviour
You can see they are not the same from that same immediate window:
? typename(vbtrue)
Long
? typename(true)
Boolean
If you convert True to a long, it will equal -1. but apparently the
properties want True or False. (an option button can be true, false, or Null
- it appears to interpret vbtrue as a request to be Null).
Don't think you need to worry about your machine.
--
Regards,
Tom Ogilvy
No need for concern. If you assign the value as vbtrue, then move from that
property, I believe you will see it gets cleared because that is not a valid
setting when set manually.
" wrote:
Hi all,
I have just noticed some odd behaviour while programming a userform in
Excel 2003 (SP2):
I have some option buttons that I set during the initialise event of
the form. I tried setting the values to 'vbTrue' and I get the
grayed-out version of the button (i.e. value = Null). If I set the
value to 'True', the button is correctly selected.
This puzzles me as I was under the impression that 'vbTrue' and 'True'
are equivalent. If I compare them in the immediate pane, they are
equivalent, and the the help for the OptionButton says that -1 (the
value of vbTrue) is an aceptable value to flag the button as true.
Had anyone else seen this behaviour, or should I start worrting about
the stablility of the system! The systems guys here do use my machine
as a test box for new patches to the system, so I'm wondering if the
latest roll-out has broken something.
Cheers,
Chris
|