I am making a form and have run into some problems.
There are several rows in the form, and the user has the possibility to add rows if he wants to (with a macro). Some rows have combo boxes or check boxes in them, and problems occur when these are copied. All contents and formatting works ok, but the new combo box is an exact copy of the original box. That is, when you copy the formula C2+D2 one row down it will change to C3+D3, but the combo box will still have the SAME cell link as the original combo box.
So what I´m asking is how to make the new control unique (the new control has the same name as the original one) and how to make its cell link to be the same as the original's, except one row below.
There are several rows in the form, and the user has the possibility to add rows if he wants to (with a macro). Some rows have combo boxes or check boxes in them, and problems occur when these are copied. All contents and formatting works ok, but the new combo box is an exact copy of the original box. That is, when you copy the formula C2+D2 one row down it will change to C3+D3, but the combo box will still have the SAME cell link as the original combo box.
So what I´m asking is how to make the new control unique (the new control has the same name as the original one) and how to make its cell link to be the same as the original's, except one row below.