I want to cut a combobox in one sheet, and then paste it in another.
Then i want to update the combobox with ListFillRange,Top and Left. My
problem is that i can't update the combobox after i've pasted it. I've
tried the following code-excample:

ComboBox1.Cut
Sheets(2).Select
ActiveSheet.PasteSpecial Format:="Microsoft Forms 2.0 ComboBox Object",
Link _
:=False, DisplayAsIcon:=False
ComboBox1.ListFillRange = "A1:B2"
ComboBox1.Top = 10
.....

Any 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=389299