LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Position of the mouse pointer Liam Excel Programming 5 October 26th 06 02:20 PM
how to drag and drop from a listbox to activecell with vba ? ka Excel Programming 2 June 24th 06 02:15 PM
Mouse pointer position, excel2002 tc Excel Programming 1 May 23rd 05 05:20 PM
ListBox drag & drop GMet Excel Programming 0 September 24th 04 03:50 PM
Urgent - Ctrl-V between sheets, not allow Drag and drop No Name Excel Programming 4 June 3rd 04 01:49 PM


All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"