Well yes there is! But how do figure out, based on mice coordinates, what's
under it.
How do I find what is the index of the ligne/item I want to move and drag to
that new position?
That's the rub mate.
"Jim Rech" wrote:
Doesn't the BeforeDropOrPaste event handler get passed the mouse pointer x
and y coordinates? I think you have to figure it out based on that.
--
Jim
"Phil" wrote in message
...
|I have a listbox which is filled at run-time and display the worksheets in
| the workbook.
| Because the number of sheets can be quite big, 50+, it is a much more
| convenient way to navigate than using the sheets tab, normally at the
bottom
| of the excel window.
| I have managed to get the Drag & Drop proc to work ok, I get the + symbol
| when I drag, but how do I determine where the pointer is?
| Or how do I get the entry that I am dragging to insert itself on mouse
| release/up?
| I have searched the internet for a few days now and the only solution I
have
| found is in VB.Net which is not good to me.
| Thank you all in advance.