positioning combo box

  • Thread starter Thread starter Noctos
  • Start date Start date
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
 
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.)
 
Back
Top