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.

Steve wrote:
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 !!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html