This seems to be a pretty frequent question in the newsgroups. You get a new mouse and the scroll wheel doesn’t work in the VBE anymore. It works normally in other programs.
When this happened to me, I downloaded the older driver and that fixed it. Specifically version 4.12 seems to do the trick. You can get mouse drivers from the Microsoft Mouse page.
If you have a Logitech mouse or a mouse based on Logitech technology, you may not want to download MS drivers for it. I’ve heard that you lose some of the Logitech functionality when you use Intellipoint drivers. If you’ve spent big bucks on a mouse and you don’t want to reduce it to the $10 version, then check out these programs:
I haven’t tried any of these programs, so use them at your own risk.
Thanks to John Flemming for the blog idea. Keep them coming.
Update: The Mouse link above doesn’t work anymore. This link does http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=4348502a-61be-4072-abe2-e3fc3aa0eee6.
I tried to use version 4.12 recently, but since I’m using Windows Server 2003, it doesn’t work for me. Instead, I installed VBScroll (the first link above) and it works like a peach.
Update: Microsoft has KB article 837910 which has a downloadable fix. The fix is for VB 6.0, so there are no guarantees that it will work for VBA, but I’ve heard it does. Here’s my favorite part of the kb article:
This behavior is by design.