drag and drop listview boxes VBA

In summary, I would like to impement a drag and drop feature across 2 listview boxes in a userform in an excel workbook, built in VBA. I have a fairly well rounded VBA programming background, but have not done much with userforms and those functions, so I'm turning to the experts.

Details:

I have an excel workbook application that I would like to build a form into that would contain two listview boxes. The first listview box is populated with data (7 columns wide) from a large table in one of the excel sheets. I have comboboxes above each column of the listview with which I can filter this table of data (works just like the "filter" feature in excel) Once I get this list filtered down to a few options, I would like to be able to select a row of data (select entire row with one click) and drag and drop a COPY of this information to the second listview box (destination list) I will need to repeat this action up to 20 more times to fill the destination list .....at which point I will click a button to export the info. So, this is the basic drag and drop capability. I will need to order the rows in the destination list....I would liek to be able to do this by just dragging the rows up or down in the destination list.....that would be perfect...if the position can be indicated with a line before the mouse button is released that would be nice too......similar to how MS windows does it when moving items around in the start menu.

Please contact me with any questions

## Deliverables

WHAT I HAVE:

I have a basic form built with the filtering comboboxes functional....and the first listview box populating itself off the filter criteria. I can send this code for you to build off of.....maybe there is a faster way to sort thru this info.

WHAT I NEED:

code written to implement the drag and drop functionality, dragging an entire row at once into a specified row of the destination listbox with the following criteria

1) if the row from the first listview is dropped between rows 3 and 4 (this is where I'm wondering if an indiator line culd show where the data will be dropped...or something to help the user), then the data will populate row 3 and shift rows 4 and higher down one.

2) if the row is dropped below all existing rows in the destination listbox, then the data will be copied to the first empty row of the destination listbox

3) if the row is dropped anywhere else besides the destination listbox, then no action is taken

========================

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows 98, 2000, XP

Microsoft Excel 97, 2000, 2003

userform built in VBA for operation within excel

PHP

Identifikační číslo projektu: #3127102

O projektu