Excel 2007 : MouseWheel on Listbox Crashes my Excel 2007

[ShredDude]

I was developing a workbook that utilizes Listboxes and their Click and Change events to then do lots of things. The workbook kept crashing, I debugged all my code, and long story short, I've isolated it down to whenever I would use my mousewheel and an ActiveX Listbox control on the sheet has focus. I first thought it was when my cursor was over the Listbox, and I used the mousewheel, but I can be anywhere on the sheet, and if a Listbox still has focus, the Wheel will Crash Excel.

I've been able to consistently replicate the bug by simply adding a Listbox anywhere in any workbook, and then trying to use my mousewheel after clicking in the Listbox, giving it Focus.. My Excel 2007, with SP1, crashes everytime! If I have a cell selected, thus no Listbox has Focus, I can use the mousewheel to scroll the entire sheet, no problems. But not the listbox contents. It crashes when the file is any of these formats, .xls, .xlsx,.xlsm.

I have found only mentions of solutions for this type of thing with regards to Access.

Does anyone have any ideas? Does this sort of thing happen on your machines, or is it just me?

I haven't figured out a way to disable the mousewheel during a listbox GotFocus, Entry or Exit event or something like that. I need to distribute this workbook I've created to other users, and it must use the listboxes. I'd hate to have to tell them to try to remember not to use their mousewheel....

[davesexcel]

Very interesting, I am still on XL2003 and the same thing happens

[ShredDude]

Thanks for the reply. I was kinda hoping I could safely distribute my workbook to 2003 users, but I guess they may have the same issue.

I noticed that my thread was moved to this Excel 2007 forum. I don't know if you did that or not, but since you're a Moderator and experience the same problem in XL2003, do you think we should maybe move it back to the Misc. forum where I originally posted it for a little more exposure? Maybe someone out there has some experience with this.


BTW, I use a Microsoft Wireless Optical Mouse 2.0. I don't know if that would have any bearing or not. I would think the mousewheel event is independent of the device that generates it.

[ShredDude]

In my workbook that utilizes listboxes, I've inserted a line in the Listboxes' click event routines that selects a cell after it does it's other stuff. This deactivates the listbox, thus preventing the mousewheel crash.

It proves to be useful, as I select the row of data that corrseponds to the values in the listbox using its listindex. the list that populates the listbox is in pane below a freeze line so a scroll wheel then spins through those rows, leaving my listboxes where they are.

Given the exercise I'm facilitating, it works out pretty well. Still annoying though that Escel will consistently crash otherwise. That needs to be fixed!!