Mouse Wheel in VBA

[John]

My mouse wheel does not function in the VBA code window. The mouse wheel does function in other windows. Is there a way to enable the mouse wheel in the code window?

 

[Paul B]

John, you should check to see if you have the latest driver for your mouse,
this has fixed the problem in the past for me. That said I just bought a new
Logitech mouse on Friday and it would not scroll in the VBA code window, I
sent a question to there tech support and was told "The reason the mouse is
not functioning properly in Visual Basic is that Visual Basic is 16 bit
application and our MouseWare is designed to work with 32 bit
applications." So much for new drivers, the old one would scroll!


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

My mouse wheel does not function in the VBA code window. The mouse wheel

does function in other windows. Is there a way to enable the mouse wheel in
the code window?

 

[Dave Peterson]

Copied from a post to PaulB (in a different newsgroup):

I've got a similar problem with an IBM Thinkpad at work.

Here's a couple links:
http://www.gasanov.net/VBScroll.htm
http://www.geocities.com/SiliconValley/2060/freewheel.html

I was using freewheel, but I'd get lockups (coincidence??). So a couple of
weeks ago, I tried the VBScroll and so far, no lockups. (But it could have been
something else causing the lockup!)

 

[John]

Thank you for responding to my original question. I have located the suggested web site for VBScroll and also found the following Microsoft Knowlwdge Base references for the mouse wheel not operating in program windows. The Knowledge Base references are 239690 (http://support.microsoft.com/default.aspx?scid=kb;en-us;239690) and 838620 (http://support.microsoft.com/default.aspx?scid=kb;en-us;838620).

838620 reads
SYMPTOM
You cannot use the products that are in the "Applies To" section to scroll in a program, although you can scroll in other programs such as Microsoft Internet Explorer.
CAUS
This behavior occurs if one or more of the following conditions are true:
You have Microsoft IntelliPoint 5.0 installed. IntelliPoint 5.0 does not provide the Universal Scrolling feature that is included in some earlier Microsoft IntelliPoint versions
The program does not provide native support for vertical scrolling
STATU
This behavior is by design.

 

[David McRitchie]

Hi John,
I think you can ignore those MS KB articles for this.

I had a problem not being able to scroll in the Microsoft VBE
I think they put the VBE into exceptions and you have to
remove that exception from Control Panel, Mouse,
Wheel (tab), Advanced options (button).

My settings basically: Device: IntelliMouse Optical,
Left Button: Click (default), Right Button: Right-click (default),
Wheel Button: Enter, Left Side Button: Back (default),
Right Side Button: Forward (default).
Wheel tab: Scroll one "screen" at a time,
[Advanced]: Only turn off IntelliPoint support for: AutoCAD, Fractal ...,
Macromedia ..., MS PhotoDraw.

on the wheel tab, advanced
remove any disable exceptions for IE and for Visual Basic

I guess they thought they could do it better themselves, but I'm
pretty sure that was where the problem was.

Let us know if that was the problem.

I'll have to put all of my settings on my site sometime.
http://www.mvps.org/dmcritchie/excel/fillhand.htm
or maybe make up a mouse.htm

 

[John]

Dave - I have a standard MS Wheel Mouse. There is no "Advanced" button on the Control Panel\Mouse\Wheel Tab. The VBScroll application from www.gasanov.net solves the problem and gives the User the option of automatic or manual start-up.

 

[David McRitchie]

Hi John,
Thanks for the feedback. have noted Shahin Gasanov's VBScroll
on my fillhand.htm page.
---
David McRitchie, Microsoft MVP - Excel

Dave - I have a standard MS Wheel Mouse. There is no "Advanced" button on the Control Panel\Mouse\Wheel Tab. The VBScroll

application from www.gasanov.net solves the problem and gives the User the option of automatic or manual start-up.

 

[David McRitchie]

I was just going through some of my web pages and found more
to move to my Fill Handle and Mouse page.

go to control panel, and click the mouse icon, then this places the
Mouse icon on the lower right tray next to the clock.
When the mouse icon is displayed like this, then I can use the mouse wheel
to scroll in Excel's VB editor.

I had forgotten about that because having that on the taskbar was an
annoyance as was having it as a running task when it seemed
unneeded but I set some tweaks somewhere so it is active but
hidden.
Mouse Problems (#mousedroppings)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mousedroppings

But I guess you don't need that now. And your LogiTech mouse
may be different setup then MS IntelliMouse Optical.