Paul,
Surely the Y position cannot relate to a row, as in one instance the mouse
could be over a row that is 3rd in the visible list, in another it could be
over the same row, but that row is 4th in the visible list.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"count" wrote in message
...
Hi,
In VBA Excel 2002 I need a way to determine over which row of a ListBox
mouse pointer is.
I know mouse Y position from BeforeDropOrPaste and need to translate it to
actual target row - for the purpose of drop-inserting.
Knowledge Base has an example that doesn't work for me -
http://msdn.microsoft.com/library/de...l/dragdrop.asp
Any known updates to the method?
TIA
Paul