Scroll wheel in Excel VBA editor

[Damien McBain]

Can I make the scroll wheel on the mouse work (ie scroll up & down) in the
Excel VBA editor? Doesn't work in the Access one either.

 

[Peter T]

I use VBScroll

http://www.gasanov.net/VBScroll.htm

This works fine for me, which reminds me I must make a donation.

Regards,
Peter T

 

[Damien McBain]

I use VBScroll

http://www.gasanov.net/VBScroll.htm

This works fine for me, which reminds me I must make a donation.

Nice, thanks Peter.

I wonder why the VBA editor doesn't do it by default?

 

[Guest]

Damien,
It's a known problem with the standard Windows mouse drivers (see Microsoft
site).
I had the same problem, then installed the Logitech mouse driver and Bingo!
VBE scrolling is fine

 

[Damien McBain]

Damien,
It's a known problem with the standard Windows mouse drivers (see
Microsoft
site).
I had the same problem, then installed the Logitech mouse driver and
Bingo!
VBE scrolling is fine

I use a number of different mice on my work laptop. They scroll everything
else except VBA editors. Unusual that the problem would be isolated like
that.

Anyhow thanks for the feed back (especially peter for pointing me in the
direction of VBScroll).

Damo

 

[Chip Pearson]

It is a problem with the Version 5 Microsoft Intellimouse
drivers. You can either revert to Version 4 or use a third party
driver product. I use FreeWheel,
http://www.geocities.com/SiliconValley/2060/freewheel.html .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[David McRitchie]

Hi Damien,
Suggest you take a look at setting up the driver as follows:
http://www.mvps.org/dmcritchie/excel/mouse.txt
which contains some other specific overrides for other applicatons.

MS Excel for Windows -- Mouse Settings
Customize
Windows START, Settings, Control Panel --> Mouse
Left Button: Left-click (global/default)
Right Button: Right-click (global/default)
Wheel Button: Enter (global *override*)
Large Thumb Button: Back (global/default)
Small Thumb Button: Forward (global/default)

Excel: Tools->Options->General->"zoom on roll with intellimouse
keep this off or you won't be able to use mouse for
a vertical scrolling, you can still use Ctrl+wheel to zoom in/out.
VBE problems with scrolling: make sure you do not have
exceptions in Control Panel, Mouse, General, Advanced
or for some older drivers there is a tab near the end
[but that would mean you are not current]

Latest Microsoft Mouse Drivers:
Microsoft Mouse | Download -- IntelliPoint Mouse Software
http://www.microsoft.com/hardware/mouse/download_ns.asp
works with Logitech mice as well but will disable itouch keyboard features

For non Microsoft mice, if MS drivers don't work either, and the MS drivers
don't work either see freewheel
http://www.geocities.com/SiliconValley/2060/freewheel.html

Although the freewheel solution Chip mentioned is frequently mentioned, I don't have it. The mouse must be active in the Windows
taskbar (next to the clock). Actually I have it hidden thanks to some startup application.