checkbox with relative reference?

  • Thread starter Thread starter Sven Berg
  • Start date Start date
S

Sven Berg

I have a checkbox in E5 controlling E5. If I copy it to K11, I want it
to control K11.
Now, how do I give it this kind of relative reference?
Thanks, Sven
 
Sven,

I take it you're going to have to do this more than a few times. I suggest
you create the checkbox objects in code rather than using the Excel Control
Toolbox. Add the checkboxes in the workbook open event and then you can set
the attributes of each using variables.

Ross
 
Back
Top