?
Solved

Drag & drop between treeview and listbox in excel VBA

Posted on 2011-10-18
1
Medium Priority
?
2,200 Views
Last Modified: 2012-05-12
Hi,
does anyone has good example how to do drag and drop from TreeView to Listbox on Userform....

Thanks in advance...

Regards...
0
Comment
Question by:alsam
1 Comment
 
LVL 19

Accepted Solution

by:
Arno Koster earned 2000 total points
ID: 36985101
you can use this :

 example-dragdrop-treeview.xlsm

pay attention though that the dragdrop event is fired before the select event. You should thus first select an item and then drag it.
regrettably the listbox does not accept OLE drag&drop so i have used another treeview instead
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question