TreeView Control V - 6.0 - Drag-Drop Nodes

[mecg96]

I am using the treeview control and have successfully created a hierarcy.
Now, I need to be able to drag and drop nodes (parents and their children or
children only) to rearrange the hierarchy, but I cannot get the OLEDragDrop
events to work.

Can anyone suggest how to accomplish this?

Thanks for your help!!!

 

[RB Smissaert]

Here is a simple example:
http://www.bmsltd.ie/Excel/SBXLPage.asp

RBS

 

[mecg96]

Awesome!!! I'm so happy I could cry :'-)

Your example did the trick perfectly!!

 

[RB Smissaert]

No problem, I learned it from there as well.

RBS

 

[(PeteCresswell)]

Per mecg96:

Your example did the trick perfectly!!

This from a noob: how did you get to look at the VBA code?

I did Tools | Macro | Macros and selected DragDropExample.xls,
but no routines showed up.

 

[RB Smissaert]

In Excel: Alt + F11 to get you in the VBE (VB Editor)
Ctrl + R to open up the Project Explorer
On the left right-click frmDragDrop and do View Code.

RBS

 

[(PeteCresswell)]

Per RB Smissaert:

In Excel: Alt + F11 to get you in the VBE (VB Editor)
Ctrl + R to open up the Project Explorer
On the left right-click frmDragDrop and do View Code.

Thanks.

Just spent the afternoon porting it to MS Access.

Not too sure what I'll ever *do* with it.... -)

But it was an instructive way to spend a few hours.