View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Wanted func to determine height of ListBox row

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