Full Version: fatal error in excel 2007 when mouse scrolling on listbox
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
stephensaid
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
KingMartin
Hi Steve,

same here... 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. sad.gif

Martin
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.