Hello

I got 2 checkboxes and I want to run a macro which depending on the value selected on the first checkbox will display a different information on a the second checkbox.

I got some questions:
--when I assign a macro to the checkbox (right click over checkbox-->assign macro), how can I access the current selected value of the checkbox?
--How can I redefine a different range to be taken by the 2nd checkbox depending on the value selected on the 1st checkbox?