checkbox with relative reference?

[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

 

[Ross Culver]

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

 

[Sven Berg]

Yes, I got to do it for a lot of times ...
Very good suggestion, thanks again. Sven