Shapes that could tick/untick a box

[Sibrulotte]

Weird eh?

I find my check box to be too small, and want to click the person's name instead.
I could assign a macro to a transluscent shape over the cell that modifies the checkbox to a specified value,

like so

Please Login or Register  to view this content.

But I want it to behave like clicking the Checkbox.

Any ideas before I start going into IF functions in the macro?

[ljungren13]

Would this work?

Please Login or Register  to view this content.

[shg]

You could instead, and more simply, use Marlett checkboxes. There are many examples in the forum, e.g., http://www.excelforum.com/excel-prog...eck-boxes.html

[Sibrulotte]

Run time error 424.
See the code above, I didn't use userforms,
I use shapes("checkbox1").

And when I try the IF function replacing Userform.checkbox1.value with ActiveSheet.Shapes("Check Box 1"),

I get error 438.

[Sibrulotte]

I looked into the Marlett Checkbox. I get it, but it merges cells and kinda looks dinky.
I see the advantage of having an actual value in a cell that could be used as reference elsewhere...

I'll try it again from blank.

[shg]

Marlett checkboxes have nothing to do with merging cells.