positioning combo box

N

Noctos

when i use a macro which is supposed to copya combo box to a locatio
the macro does not paste the box to the right place it pastes it righ
beside the original box. is there a way i can position the paste
combobox to my desired locatio
 
D

Dave Peterson

Can you just paste it where you want it?

Option Explicit
Sub testme01()
Worksheets("sheet1").ComboBox1.Copy
Application.Goto Worksheets("sheet2").Range("b19")
Worksheets("sheet2").Paste
End Sub

(I chose B19 of Sheet2.)
 
Top