LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default Possible BUG (Listbox item selection)

I have been fighting a very strange issue with a listbox.

I am using the Before doubleclick event from a worksheet to trigger a
dynamic build of a rowsource for a listbox with a .show that should wait on a
selection from the listbox to then populate the cell that was doubleclicked.

The issue is that the 2nd click of the double click is being picked up by
the listbox as a selection.

I have verified this behavior by shifting the mouse a few pixels outside of
where the listbox will showup and the event coding works as designed.
Anytime the double click is in the same screen area that the listbox shares,
the 2nd click is taken as the choice.

I tried adding a delay loop before the doublelcick event code would execute
the form.show command, but that still did not prevent the form_Click code
from running and choosing the item from the list that just happened to fall
under where the mouse was initially positioned.

I figure that forcing the box to position itself away from the double click
may work, but that is at best just a band-aid for the problem. But might be
the only workarround.

Any thoughts of what to try to get around this issue?

--
Regards,
John
 
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
Adding item in listbox volabos Excel Worksheet Functions 0 December 3rd 07 11:27 AM
listbox add item Baha Excel Programming 0 December 8th 06 02:37 AM
Add item to listbox, but only if it is not already there. Mark Excel Programming 4 September 2nd 05 10:07 PM
The value of a ListBox Item TK Excel Programming 2 August 20th 04 06:17 AM


All times are GMT +1. The time now is 08:11 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"