checkbox cell range change vba

[novitaun]

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?

[Richard Buttrey]

Hi,

Presumably you're referring to the Excel checkbox control rather than the Activex UserForms controls in the VBE?

The view Code window of the checkbox is actually the Checkbox_Click event, and the default values are either True or False. e.g. put the following in the code

Sub Checkbox1_click
 MsgBox Checkbox1
End Sub

and see it toggle between True/False as you click the button. Hence you access the value by simply referring to it.

I'm confused by your second question. Are you sure you really mean a checkbox? A checkbox can't 'take a range', it's essentially just a binary control. You can check the state of a checkbox and do things like naming a range according to its state, but in that case you'd presumably build that into the Checkbox 1 click event.

Can you explain a little further