| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I write code to enable drag/drop from ListBox on UserForm to a cell.
Hi,
I have a userform with a listbox. I want to enable drag/drop from the listbox to a cell. A ListBox does not have DragBehavior property unlike a ComboBox. How do I do that? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I write code to enable drag/drop from ListBox on UserForm to a cell.
Hello
You could use a textbox control with its DragBehavior property enabled and place the selected element from the list using the Listbox_Click event for instance. HTH Cordially Pascal "Zoo" a ecrit dans le message de news: ... Hi, I have a userform with a listbox. I want to enable drag/drop from the listbox to a cell. A ListBox does not have DragBehavior property unlike a ComboBox. How do I do that? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I write code to enable drag/drop from ListBox on UserForm to a cell.
Thank you for your reply, papou.
Do you mean that the textbox should be placed on the ListBox? ______________ |ListBox | | ___________ | ||TextBox| | <- TextBox on ListBox? ||___________| | |______________| "papou" wrote in message ... Hello You could use a textbox control with its DragBehavior property enabled and place the selected element from the list using the Listbox_Click event for instance. HTH Cordially Pascal "Zoo" a ecrit dans le message de news: ... Hi, I have a userform with a listbox. I want to enable drag/drop from the listbox to a cell. A ListBox does not have DragBehavior property unlike a ComboBox. How do I do that? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I write code to enable drag/drop from ListBox on UserForm to a cell.
Oops apologies, this suggestion was stupid!
Place the Textbox somewhere in your Userform so that you can drag and drop its value onto your sheet. And make it visible! ;-) Cordially Pascal "papou" a écrit dans le message de news: ... Hi No, I mean it could be placed on your Userform, and may be with its Visible property set to false so that it won't confuse users. HTH Cordially Pascal "Zoo" a ecrit dans le message de news: ... Thank you for your reply, papou. Do you mean that the textbox should be placed on the ListBox? ______________ |ListBox | | ___________ | ||TextBox| | <- TextBox on ListBox? ||___________| | |______________| "papou" wrote in message ... Hello You could use a textbox control with its DragBehavior property enabled and place the selected element from the list using the Listbox_Click event for instance. HTH Cordially Pascal "Zoo" a ecrit dans le message de news: ... Hi, I have a userform with a listbox. I want to enable drag/drop from the listbox to a cell. A ListBox does not have DragBehavior property unlike a ComboBox. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable/Disable Drag and Drop in Excel 2003 via Registry | Excel Discussion (Misc queries) | |||
| how to drag and drop from a listbox to activecell with vba ? | 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
