Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

Strange Option Button behaviour

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
christopher.lepingwell@gs.com - 21 Mar 2006 12:56 GMT
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
Tom Ogilvy - 21 Mar 2006 13:37 GMT
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.

Signature

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.  

> Hi all,
>
[quoted text clipped - 19 lines]
>
> Chris
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.