View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
PR Joseph Oget PR Joseph Oget is offline
external usenet poster
 
Posts: 3
Default Drag & Drop in ListBox Ctrl: Find pointer position on mouse up

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.