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
>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 Berg - 21 Apr 2008 08:21 GMT
Yes, I got to do it for a lot of times ...
Very good suggestion, thanks again. Sven
> Sven,
>
[quoted text clipped - 11 lines]
>
> - Zitierten Text anzeigen -