How do I copy a combo box?

[Guest]

When I copy a combo box, the new box is synchronized with
the first box. I.E, when a make a selection in the first
box the same selection is made in the new box.

Is there a way to copy a combo box to avoid this. I am
using a Forms control, not ActiveX. I unlocked the
control, removed any $'s in the cell link reference. All
to no avail.

Please help.

 

[Vasant Nanavati]

Change the cell link to another cell manually. Copying a combo box preserves
the original cell link, even if relative notation was used.