Condition code True False on Checkbox

Hi again,
I am playing around with checkboxes to see how to control events such as clicks
I have coded a very basic sheet to teach me return values of acheckbox variable that is not working as I would expect.
The code I am using is

Please Login or Register  to view this content.

I have attached the spreadsheet so you can see what happens when you click each checkbox
I would have thought that Cells G1:G3 would have the values
and that F1:F3 would have the dates.
what did I do wrong ?

Also as you can see I tried Private for checkbox1
not sure exactly what Private will do or not do but neither of the checkboxes work as expected
any information about when to use private vs not would also be appreciated.

Happy Holidays
RobertCo

I think I figured it out although I still do not know why.....

There are two types of checkboxes,
On from the forms toolbar and one from the control toolbox.....
Why the difference in what they do ?



attached is the new spreadsheet with using the control toolbox Checkbox's

works as espected but again not sure what the differences are.

Originally Posted by RobertCo

I think I figured it out although I still do not know why.....

There are two types of checkboxes,
On from the forms toolbar and one from the control toolbox.....
Why the difference in what they do ?



attached is the new spreadsheet with using the control toolbox Checkbox's

works as espected but again not sure what the differences are.

Either can work 'as expected' - it just depends what you expected, see the attached two sets for different response.

The Forms version needs 'assign macro', whereas the Toolbox version expects own code, but the code follows only what you put in.

hth
---