Combo box copy data
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 !! -- Thanks Steve |
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 |
All times are GMT +1. The time now is 08:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com