Syntax Issues with Placing Checkboxes

[phelbin]

I found some nifty code that 90% solves my problem, but I need to tweak it a bit. This code brings up message boxes to define the range and linked column and then places checkboxes. In my situation I want to set the range and linked column and not use the message boxes, but I just can't get the syntax to work.

Any ideas?

Please Login or Register  to view this content.

Thanks!!




BTW, I found it here:
http://www.terminally-incoherent.com...-the-easy-way/

[Norie]

How do you want to set the range and linked column?

This code will create 10 checkboxes in A1:A10 linked to column D and with the caption "MyCheckbox"

Please Login or Register  to view this content.

[phelbin]

Norie, you're the best!! It works exactly as I hoped it would.

Thanks so much!