Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy and move check box (check boxes) with new cell link?
Hi,
I have created a document with text, check boxes and IF formulas dependant on the TRUE or FALSE values for each of the check boxes. This was done over time and it is fairly extensive at this point and I would like to duplicate that document on the same sheet about 6 to 8 times below the original. When I copy the document and paste it below the original (text, formulas and check boxes), the references (cell link) for all of the check boxes are linked to the original document (clicking a check box in the copied document add a check mark to both the copied and original check boxes which I do not want). I have used the "form" check boxes. Is there a way to copy and paste check boxes and obtain a new cell reference? Other recommendations? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy and move check box (check boxes) with new cell link?
Please try this on a copy of your worksheet.
Adapt column D to suit your cell link. i.e. cell link is Gx Change "D" to "G" Sub change_forms_checkbox_links() Dim mychkbox As CheckBox Dim wks As Worksheet Set wks = ActiveSheet For Each mychkbox In wks.Checkboxes With mychkbox .LinkedCell = wks.Cells(.TopLeftCell.Row, "D") _ .Address(external:=True) End With Next mychkbox End Sub Gord Dibben MS Excel MVP On Wed, 20 Jan 2010 08:10:01 -0800, Marty wrote: Hi, I have created a document with text, check boxes and IF formulas dependant on the TRUE or FALSE values for each of the check boxes. This was done over time and it is fairly extensive at this point and I would like to duplicate that document on the same sheet about 6 to 8 times below the original. When I copy the document and paste it below the original (text, formulas and check boxes), the references (cell link) for all of the check boxes are linked to the original document (clicking a check box in the copied document add a check mark to both the copied and original check boxes which I do not want). I have used the "form" check boxes. Is there a way to copy and paste check boxes and obtain a new cell reference? Other recommendations? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell link for many check boxes at once | Excel Discussion (Misc queries) | |||
link to check boxes | Excel Discussion (Misc queries) | |||
Check box cell link - copy problem | Excel Discussion (Misc queries) | |||
How do you link Check Boxes? | Excel Discussion (Misc queries) | |||
why do check boxes move when printing excel spreadhseets | Excel Discussion (Misc queries) |