| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to drag and drop from a listbox to activecell with vba ?
Hello,
how to drag and drop from a listbox to activecell with vba ? Thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to drag and drop from a listbox to activecell with vba ?
Thanks you Ron de Bruin, it's ok !
bye "Ron de Bruin" a écrit dans le message de news: ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to drag items within listbox | Excel Discussion (Misc queries) | |||
| Paste Multiple listbox items starting at ActiveCell | Excel Programming | |||
| ListBox drag & drop | Excel Programming | |||
| Func wanted for drag/drop in ListBox | Excel Programming | |||
| Drag/drop - calc of ListBox row wanted | Excel Programming | |||
Linear Mode
