checkbox with relative reference?

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
 
R

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
 
S

Sven Berg

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