Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Position of the mouse pointer | Excel Programming | |||
how to drag and drop from a listbox to activecell with vba ? | Excel Programming | |||
Mouse pointer position, excel2002 | Excel Programming | |||
ListBox drag & drop | Excel Programming | |||
Urgent - Ctrl-V between sheets, not allow Drag and drop | Excel Programming |