Check Box Cell Link

[1vision]

Do all the cell links for the check boxes need to be done manually or can excel do the links automatically.

Just like when you copy and paste a cell with a formula to another cell, it copies the formula but updates the cells its referencing to.

I want to do the same thing with the check box. but when I paste the check box, it keeps the original reference cell link. I already made sure what the cell link is not absolute.

Or am I going about this wrong.

Thanks for your help.

[Ron Coderre]

Here's a VBA solution.
The below process sequentially sets the cell link for each checkbox to the cell under the upper left corner of the checkbox.

• Select your workbook
• ALT + F11...to open the vba editor
• Insert.Module...to create a general module in that workbook
• Copy the below vba code and paste it into that module

Please Login or Register  to view this content.

Replace Sheet1 with the name of the worksheet containing your checkboxes
To run the code:
• ALT+F8
• Select SetCbxLinks
• Click: Run

Is that something you can work with?

[1vision]

Let me try it.

[1vision]

I like it... Thanks. I'm a beginner with VBA Programming. How do I control what cells should be linked? My form I have the check box in Column Z, I need to link the cell that is 4 Cell to the right (Column AC). How would I go about this?

And once again what a great help. I have about 900 Check boxes I would of had to do manually. Thanks

[Ron Coderre]

Here you go:

Please Login or Register  to view this content.

If the checkboxes are in Col_A, that code puts the links in Col_E.

Does that help?

[1vision]

Perfect this helped tremendously. Thanks for the help.

[compu829]

I know this is an old thread, but I made the following tweak to the code so that it will always work dynamically with the active workbook and worksheet.

Please Login or Register  to view this content.

I am still floored that I had to resort to this for basic functionality that should be included in Excel!