You need to copy the code as well. Take a look at
www.cpearson.com/excel/vbe.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MBais" wrote in
message ...

Hi

My problem is when i try to cut and paste a combobox from one sheet to
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 i
paste it all the added items are lost. I have also tried to copy the
combobox to another worksheet, and everything seems fine with the
original combobox containing all the added items. This is the code
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 the
ListFillRange in properties add items to the combobox and cut/paste the
combobox everything goes just fine.

All help, is good help


--
MBais
------------------------------------------------------------------------
MBais's Profile:
http://www.excelforum.com/member.php...o&userid=25476
View this thread: http://www.excelforum.com/showthread...hreadid=389800