Combo box copy data

S

Steve

Can any one help?

i want to copy a work sheet containing a combo box, how ever the data from
the Combo box does not come over with the copy how can i acheive this !!
 
D

Debra Dalgleish

If you've used a combo box from the Forms toolbar, right-click on it,
and choose Format Control
For the Input Range, include the Sheet name, e.g.: Sheet1!$A$1:$A$11
For the Linked cell, include the sheet name, e.g.: Sheet1!$L$1

When you copy, the combo box should retain the information from the
original sheet.
 
Top