I have a sheet that lists stats for random items and each item has about 120 check boxes that need to be applied. Each linked to there own cell.

In every case Ive used the +alt method to place each checkbox in its cell, Is there a macro I could run that would link each one of those checkboxes to the cell immediatly to it's right.

Ive been tinkering with this for a couple of days now and its stoped being fun for me about a couple of days ago. If anyone could help me with this that would be fantastic.

P.S. Im using Office 2007 and the checkboxes from the Forms Menu.