how to drag and drop from a listbox to activecell with vba ?

  • Thread starter Thread starter ka
  • Start date Start date
K

ka

Hello,

how to drag and drop from a listbox to activecell with vba ?

Thanks,
 
Hi Ka

You can use the Double click event maybe ?

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
ActiveCell.Value = Me.ListBox1.Value
End Sub
 
Thanks you Ron de Bruin, it's ok !
bye


Ron de Bruin said:
Hi Ka

You can use the Double click event maybe ?

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
ActiveCell.Value = Me.ListBox1.Value
End Sub
Click to expand...
 
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

How do I write code to enable drag/drop from ListBox on UserForm to a cell. 4
Worksheet and Listbox 2
Create a activecell from the listbox? 3
Select range from ActiveCell do to Lastcell 5
select a specific ActiveCell by VBA 3
Excel Applying Code to a Column 0
Access Using DAO.Database VBA code to populate a listbox from another listbox selection 1
Close na "on the fly" created Listbox if ignored by the user? 1

Back
Top