Checkbox to write values to multiple cells

[DoesNotKnow]

Hi

I need some help with the following.
I have a checkbox when checked reveals hidden rows.

Now I would like when the same checkbox is checked that it would also populate multiple cells in a single column with various numbers. and when it is unselected the cells go back to value of 0.

Ex. Checked, Cell E2 = 4, E3 = 1, E4 = 2, etc etc.
Ex. Unchecked, all previous cells = 0

Thank you,

[SamT]

We need to know if it is a "Forms" CheckBox, or a "Control ToolBox" CheckBox. All we can surmise right now is that it is not a VBA Userform CheckBox, all three are treated differently.

IMHO, the "Forms" Controls are the most difficult to work with.

[Paul_Hossler]

Hi

I need some help with the following.
I have a checkbox when checked reveals hidden rows.

Now I would like when the same checkbox is checked that it would also populate multiple cells in a single column with various numbers. and when it is unselected the cells go back to value of 0.

Ex. Checked, Cell E2 = 4, E3 = 1, E4 = 2, etc etc.
Ex. Unchecked, all previous cells = 0

Thank you,

Please show the code

Use the [#] icon to insert [CODE] .... [/CODE] tags and paste the macro between then

[DoesNotKnow]

It is an ActiveX control Checkbox

[SamT]

Gee, I'm really stupid ...Is that a Forms control or a Control Toolbox control.

[Paul_Hossler]

Things have changed since 2003

You can put an ActiveX control on a sheet ...

Capture.JPG


... and it has it's own event handler in the worksheet's code page

Capture1.JPG

[SamT]

Things have changed since 2003

Not Really. Only the name has changed, because the Menu Bar was scrapped for the Ribbon by the Jeune École at MS. They were simply Control Toolbox Controls. But thanks for answering my question, but I already knew the answer. I just HATE IT when new poster doesn't answer our questions.