checkboxes

M

mark

checkboxes, when linked to cells, store either TRUE or
FALSE in them...

Boolean...

is it possible to set the default item stored to 1 and 0 ,
so that a PivotTable could work with the sums better?

I can run through and change the TRUE/FALSE to 1/0 if I
need to, but it will just take extra time.

Thanks.
 
C

cmart02

The default value is either true or false. You cannot have 1 AND 0 at the
same time as argumentos of a boolean control as it can only assume either one
state or the other.
 
N

Nigel

Not entirely true, since the triple state property allows the control to
take on a null value. Thus there are three valid values: null, true or
false.
I do not believe you can return a 0 or 1 from the control, however you can
set the value to 0 and 1 for true or false.

Cheers
Nigel
 
N

Nigel

I have discovered that if you multiply the value of the check box by -1 ,
then you get a 0 or 1 returned.
If you are saving the value to the worksheet, then use

Range("A1").Value = Checkbox1.Value * -1

Cheers
Nigel
 
M

mark

If you are saving the value to the worksheet, then use
Range("A1").Value = Checkbox1.Value * -1
Click to expand...

looks like something along that line is what I'll have to
do, though I may just do it in a summarization
spreadsheet, instead of actually using the code in the
evaluation form that this is in.

thanks.
Mark
 
Top