Dear all,

Using the forms toolbar I have created a combo box which is located in cell
A1: input range: $Z$1:$Z$5; cell link B1.

If I copy the cell and paste into B1 the combo box is copied. However the
cell link remains as B1?!

Is there a way I can copy the cell and combo box so that the cell link moves
to, i.e. becomes B1?

I need to create 30 cells with combo boxes with the same input range but
individual cell links.


Thanks in advance.


Kind regards,

Neil