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
(E-Mail Removed)





"Helmut Weber" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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"
>
>
> -