Mouse Scroll event in listbox kills Excel

S

Stuck

When creating a vba list box in excel, word, or powerpoint version 2000 or
2003 (with or without sp3) or Excel 2007, the application disappears with
creates a general exception error. Excel just dies. I'm not creating a
form,
just inserting a listbox on the document, sheet or presentation and then
scrolling in it with the mouse wheel. This doesn't happen with a combobox

Steps to reproduce.
1. View, toolbars, visual basic.
2. Create a list box on the sheet from the tool bar.
3. Get out of design view.

This has been around a long time, evidently, and I've posted it on a couple
of listservs, but hasn't been 'noticed', again evidently, until recently.

THIS IS A BUG. Or, has anyone found a workaround for this besides using
the scroll bar? It is a natural thing to do to scroll the wheel as well as
click the scroll bar, and the event should be caught, not create an exception
error and blow up!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communitie...e4f0630&dg=microsoft.public.excel.programming
 
T

Tim Zych

I created a listbox from the Control Toolbox toolbar (there's no Listbox on
the Visual Basic toolbar, just a Control Toolbox icon which pops up the
Control Toolbox ActiveX controls toolbar), then scrolled the mouse wheel,
and the sheet/listbox scrolled as expected. Nothing bad happened. XL 2003,
Logitech mouse.

Although I don't see how you can scroll "in it", being that's it's an empty
listbox. I can't even give it focus using the mouse outside of Design View.
 
S

soeyken

I've also this "bug" problem,
but only in Excel 2007 build 4518

I can not reproduce this behaviour in Excel 2003 build 8169 (the mouse
scroll simply does not work there, so it doesn't crash there)

Anyone else?
 
P

pierre.bodineau

I have got this behaviour too...
from Office 2000 till 2007 version...








- Show quoted text -

Same thing for me, it is very annoying

Nobody knows how to fix this? Is there an OCX file (or something like
this) to change to have an other version of this control?

Any help will be useful

Thanks
 
F

fab222.andrey

Same thing for me, it is very annoying

Nobody knows how to fix this? Is there an OCX file (or something like
this) to change to have an other version of this control?

Any help will be useful

Thanks

hi guys
I have done it!!

i had the same problem with a wheel mouse. it crashed my excel 2007
when i used one in a listbox.
there were 3 computers with the same problem (XP and vista). we worked
with a logitech optical wireless mouse and simple usb mouse.
in my case the source of the problem was a standard driver for a
microsoft mouse. it was used by default in the computers. after the
driver has been changed i have happy. :)
but the scroll with the wheels doesn't work in a listbox. :(
 
T

TOYOTA

My problem sounds very similar except I am not creating a list box but rather
just trying to use a list box in a spreadsheet created January of 2004. If
my mouse is in the box and I accidentally hit the wheel on the mouse I crash.
It's worked fine until about a month ago. Does anyone know of a fix?
 
P

Peter

I am experiencing this list box/scroll wheel problem in 2003 (11.8302.8221).
That hotfix is for 2007. Any kb available for us old guys?
 
J

Jeff

I had the same problem w/ Excel 2003 SP3. I've been using the same
spreadsheet with several listboxes for months and never noticed it until
today. I don't explicitly remember using the scroll wheel in the box, but it
seems odd that I wouldn't have...

I didn't find a solution, but I did update my mouse driver (from logitech).
Now the wheel doesn't work, but at least Excel doesn't crash. If anyone
knows how to make the wheel work, I'd be interested to know.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top