Hi everybody,

once again i'm stumped by Excel.
Should a checkbox's value from the forms toolbar
not be true (-1) or false (0),
apart from undefined (mixed) 2?

Apparently it isn't.

OK, I can handle that.
But have I missed something?

Help on checkboxes offers:
Excel Checkboxes(...
Excel Checkboxes
Office Checkboxes

First two topics lead to grey empty pages,
or to nothing, you may say.
Third topic leads me to the balooncheckboxes collection...

Though this be madness, yet there is method in it.
What method?


--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"


-

they return xlon and xloff

? xlon
1
? xloff
-4146

If you want a document that discusses dialogsheets/forms controls, send me
an email with where to send it.


--
Regards,
Tom Ogilvy






"Helmut Weber" wrote in message
...
Hi everybody,

once again i'm stumped by Excel.
Should a checkbox's value from the forms toolbar
not be true (-1) or false (0),
apart from undefined (mixed) 2?

Apparently it isn't.

OK, I can handle that.
But have I missed something?

Help on checkboxes offers:
Excel Checkboxes(...
Excel Checkboxes
Office Checkboxes

First two topics lead to grey empty pages,
or to nothing, you may say.
Third topic leads me to the balooncheckboxes collection...

Though this be madness, yet there is method in it.
What method?


--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"


-