I have a form, with columns of boxes which a person either double clicks in or use a button what puts a wingding check or x in the box. This is reflected on up to three other sheets with identical form but the use of the "='sheet2'!B1" link. My problem is, this form is reused, therefore if a change is made in these mirrored cells, the formula is gone. I found some vba to do this, which I use for one column, but it does not work 100% when I try to use it for the five columns on the sheet. The odd thing is, if I multi-select two or more cells and use my vba button to put a "P", it does not populate the first cell in the column. I am also wondering if just putting the formula in the code, then in an macro which asks the user if they want to continue using the same form, it could write the formulas back into the cells, such as this "Sheet17.Range("R128").Formula = "='L-EX 1_2&4-VP(51)'!R128"". For you experienced folk, which method is more efficient or better, or is there still a better way than this? I have attached the vba which I have been using for the one column. Thanks!
Please Login or Register  to view this content.