Checkbox Question: when checked, then A1 cell to take value 5 and when unchecked 0

Hello all

I m trying to figure out what is happening with CheckBoxes

What i want is this. I insert a checkbox from FORM CONTROLS in the sheet. I want when this checkbox is checked, then A1 cell to take value 5 and when unchecked the value 0 .. this simple thing.

(In my fact my problem is that i cannot find the name of the checkbox since I have change it many times... How can i find what is the name and how can i call it to run a sub ? )

thank you

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are still new here, I have done it for you this time.)

The name should appear in the name box, next to formula bar.
Or you can use ALT+F10 to display selection pane. All shapes will be listed.

you could use code

Please Login or Register  to view this content.

Although no code is necessary if you Link the checkbox to B1 you can then use a formula in A1
=IF(B1,5,0)

you said the control was from Forms, where as your code would suggest ActiveX control.

If you assign the macro to the form control then Application.Caller will contain the name of the shape that was clicked.

You also seem to have changed what you want put in A1. first it was 5 and 0, now it's 1 and zero.


If it is a activex control then you could use

Please Login or Register  to view this content.

Just assign the macro to the control.

Example shows control and code in module1

Thank you. The attached file works perfectly. I have to check my code why it does not run to me... probably i run some protection in cells for other routines.

update. please check message below

You could create a structure like this and assign it to every CheckBox.

Couldn't post the code here because Firewall error. See attached file.

The name of the macro is autogenerated, in this case it reflected the name of my form control. But you can call it what ever you want.

As I said previously, when macro is called by clicking a shape, which has the macro assigned to it, the application.caller will contain the name of the shape.