Hi

My problem is when i try to cut and paste a combobox from one sheet t
another.

The thing is that i first update the combobox by the addItem function
then i cut the combobox and paste it in another worksheet. But when
paste it all the added items are lost. I have also tried to copy th
combobox to another worksheet, and everything seems fine with th
original combobox containing all the added items. This is the cod
sequence:

"an addItem loop adding the elements" then
ComboBox1.Cut
Workbooks("The workbook").Sheets("The sheet").Activate
ActiveSheet.Range("The Range").Select
ActiveSheet.Paste

What seems a bit strange to me, is when I manually with th
ListFillRange in properties add items to the combobox and cut/paste th
combobox everything goes just fine.

All help, is good hel

--
MBai
-----------------------------------------------------------------------
MBais's Profile: http://www.excelforum.com/member.php...fo&userid=2547
View this thread: http://www.excelforum.com/showthread.php?threadid=38980