Form Control

[Tammy]

I am trying to use the checkbox form control in an Excel
spreadsheet where the checkbox value (true/false) is
linked to a cell. I can get the form control to work just
fine, however when I copy and paste the control to another
field, the cell link does not automatically change. I
have tried removing the $ from the cell link reference,
but the cell does not change. Since I have about 200 rows
which need this checkbox control, it would not be
efficient for me to manually change the cell reference in
each control property. Is there someway I can get the
cell reference to change when I copy/paste it?

Thanks in advance for any info you can provide.

 

[Debra Dalgleish]

Dave Peterson posted some code that you could modify and use to add the
checkboxes:

http://groups.google.com/groups?&[email protected]

 

[Dave Peterson]

Or just look at your other post.

Dave Peterson posted some code that you could modify and use to add the
checkboxes:

http://groups.google.com/groups?&[email protected]