UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> fatal error in excel 2007 when mouse scrolling on listbox    
 
   
stephensaid
post May 28 2007, 07:41 AM
Post #1

UtterAccess Veteran
Posts: 450
From: Malta
Hi All,

Please have a look at the attached sample.
Try giving focus to the list box by choosing a value in the listbox.
Then scroll with your mouse, while focus is in the listbox. A fatal eror in excel is caused.

I am using Excel 2007. Any ideas how to avaoid this problem.

Thanks in advance
Stephen
Attached File(s)
Attached File  test.zip ( 15.65K ) Number of downloads: 6
 
Go to the top of the page
 
+
KingMartin
post May 29 2007, 04:26 PM
Post #2

Retired Moderator
Posts: 10,959
From: Prague,CZ / Kiev,UA
Hi Steve,

same here... (IMG:http://www.utteraccess.com/forum/style_emoticons/default/shrug.gif)

Try to get the focus away from the listbox:

CODE
Private Sub ListBox1_Change()
Range(ListBox1.LinkedCell).Select
End Sub


If you wanted to scroll through the list using the rodent's scroll wheel, then this is not possible, I am afraid, but I'll be happy to stand corrected. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

Martin
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 08:43 PM