mouse wheel exception error in office products.

[Tim H]

Heres a good one.

When creating a vba list box in excel, word, or powerpoint version 2000 or
2003 (with or without sp3) The application disappears of creates a general
exception error. I'm not creating a form, just inserting a list box on the
document,sheet or presentation.

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.

With the mouse wheel, hold the wheel down in the list box and scroll. It
takes just one tick and boom. The mouse works in all of the applications as
expected (other than the list box). I've tried it on serveral machines
(xp,2k,2k3 standard and prof.) and several mice (microsoft ps/2 and usb).
When doing this same process in a vba form, the problem does not occur. Dont
know where to turn. Any help would be greatly appreciated.

Tim

 

[Jean-Guy Marcil]

Tim H was telling us:
Tim H nous racontait que :

Heres a good one.

When creating a vba list box in excel, word, or powerpoint version
2000 or 2003 (with or without sp3) The application disappears of
creates a general exception error. I'm not creating a form, just
inserting a list box on the document,sheet or presentation.

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.

With the mouse wheel, hold the wheel down in the list box and scroll.
It takes just one tick and boom. The mouse works in all of the
applications as expected (other than the list box). I've tried it on
serveral machines (xp,2k,2k3 standard and prof.) and several mice
(microsoft ps/2 and usb). When doing this same process in a vba form,
the problem does not occur. Dont know where to turn. Any help would
be greatly appreciated.

Tim

I could not reproduce your situation in Word 2003 SP2.
Well, at least, I think I followed your steps. There are not actual controls
on the Word VBA toolbar, you have to use the Controls Toolbox for that.

I created a list, used code to add 4 items to it.

With ThisDocument.ListBox1
.AddItem "One"
.AddItem "Two"
.AddItem "Three"
.AddItem "Four"
End With

Then, I got out of design mode.
If I selected an item and tried to scroll with the mouse wheel, the whole
document moved.
The only way I could scroll the list in the list box with the mouse wheel
was to hold down the left mouse button and then scroll. I do not think that
many people do that!. Any way, even then, the list scrolled fine, and as
soon as it got to the bottom or top, the whole Word document went on
scrolling instead.
Never had an error.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[xmasgoose]

I have been having the same problem with list boxes in Excel 2003 for several
months. I have only just worked out that it is the mouse wheel scrolling that
causes the problem. Just letting you know that you are not alone and I
haven't found much about it on the internet. If you have resolved the
problem, I would appreciate your help.

David

 

[Russ]

Tim,
I'm not sure what you have setup for a wheel button preference in your apps
or globally, but following Jean-Guy's method, maybe you could set up the
wheel button to be a 'left click' in the Office applications.

 

[cedron]

recently i've been using a lot of these listboxes in my excel projects too
and have just found the same bug you're talking about... well i guess it's
not best to use a mouse wheel this time coz the bug's still out. btw, i'm
currently using office 2007. i hope we'll get our support guys

 

[rickp]

I have the same situation as cedron. I see the same bug with an excel app
using 2007 and 2003. Tim's set up is all that should be necessary to see the
error.