Thread: how to drag and drop from a listbox to activecell with vba ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default how to drag and drop from a listbox to activecell with vba ?
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

--
Regards Ron De Bruin
http://www.rondebruin.nl



"ka" wrote in message ...
Hello,

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

Thanks,






Reply With QuoteReply With Quote