Cell Link assignment for check boxes

**modytrane** · 04-17-2009, 03:46 PM

Is there a way to create a check box, assign cell link,
then copy the check box multiple times and have the cell link follow in a relative fashion.
In other words all subsequent check boxes would have different cell links.
modytrane

**Mallycat** · 04-17-2009, 06:59 PM

I doubt it. I am pretty sure there is no referential relationship between an object you add to your sheet and the sheet itself. How would it know which cell to reference to when it was copied?

**Leith Ross** · 04-17-2009, 09:20 PM

Hello Modytrane,

I revised this macro I wrote a back in March. This macro will automatically add a CheckBox to each cell you have selected. When it starts, you will be asked if you want to add a macro and a linked cell to the check boxes. The same macro will be run by each check box if you choose to add one. The link cell will update based on Excel's absolute and relative referencing for A1 style entries. You can link to another worksheet when prompted by including the sheet with the range, like this...

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

**modytrane** · 04-18-2009, 11:55 AM

Leith,
The macro works well, thank you.
I am not sure about the size of the check box though.
It seems like the size is same regardless of the cell size.
I have another thread for that issue, but since you mentioned that your macro addresses the size, I thought I would ask you here.
I'll make sure to close the other thread if it gets addressed here.

Thanks again,
modytrane.

**Leith Ross** · 04-18-2009, 12:52 PM

Hello moodytrane,

When I first wrote the macro, it was to add a check box without a caption that would match the cell's height. Tell me what you need and I'll modify the code for you.

**shg** · 04-18-2009, 02:45 PM

Modytrane, are you familiar with Marlett checkboxes? They are easy to implement in code, and are on the same layer as the rest of the data. Here's an example:

In the sheet module:

Please Login or Register  to view this content.

In a code module:

Please Login or Register  to view this content.

**modytrane** · 04-20-2009, 01:41 PM

shg,
I am not familiar with the Marlett checkboxes.
I'll look in to it.
Thanks for the suggestion.

Leith,
As I said before, your macro works but the size of the checkbox seems to be fixed relative to the cell.
Is there a way to modify your macro, so that the checkbox will be as high and as wide as the cell? Or is it possible to size the checkbox manually?
Thanks for your help,

modytrane.

**escobf** · 05-31-2013, 10:58 AM

@ shg, I have come across this thread in an effort to modify my Marlett Checkbox code and you seem to be very familiar with this. I am trying to figure out how to make the Target cell where the "a" actual goes in a different cell (different column in a second table) from the cell that is actually selected.

Does this make sense? Any help is greatly appreciated

**arlu1201** · 05-31-2013, 11:17 AM

escobf,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.