Perhaps link the checkbox to a cell, then use a reference to that cell in
your formula.

Right click on the checkbox and select Properties, then use the linked cell
property.

Sheet1!A1

as an example.

--
Regards,
Tom Ogilvy



"calculate checkBox value in a sheet" wrote:

How can I use the component checkBox in my sheet and after user check/uncheck
this component I will calculate the value according to the formula I have