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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Postioning combo box 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Copying Combo Boxes?! 5
Changing the location of a file through 1
Is this possible? 4
Add a combo box 1
Combo box result text not number 2
Changing the format of text in a combo box 1

Back
Top