Folks
The mouse scroll wheel does not work in VBA. This has always puzzled me as to why this support does not exist since Office 2000.
This problem was originally caused by a MS Mouse driver change that
I'm told was communicated long in advance to other MS folks.
This problem has existed for several versions of Office. As far as
I'm concerned this should've been fixed in the Office SPs.
And yes, I'm quite aware of the workarounds VBScroll and Freewheel.
Tony
Lack of mouse scroll wheel support in VBA
GETE
Hi.
About this subject.
I have seen several cases on Internet and at my job where we are requiring that when we move the mouse scroll wheel, Access does not change current record.
I'm designing a DB, but, when user moves Mouse Scroll Wheel, Access changes record, and it can to add new records.
I found some messages on another forums and they talk about make a DLL or copy a DLL, but, this doesn't work for network aplications (not all work stations have this DLL file)
I hope you can help me
VaibhavG
Yacine Benahmed
This would be the VBA editor. So when I'm in code, in my case MS Access, and it's longer than a page, I can't use the scroll wheel on the mouse to scroll up and down. Just like I can when using IE, Notepad, Word or any other environment.
Business case There are work arounds with free third party utilities. As previously mentioned in this thread. I just feel that missing this support is rather embarrassing for Microsoft.
If desired I'll be happy to make up a fake MDB with some code and provide the exact steps to get to the VBA Editor and show how the mouse scrool wheel doesn't work.
This problem is documented at
Mouse wheel events do not work in the Visual Basic 6.0 IDE
http://support.microsoft.com/ id=837910
but I don't think the first work around mentioned is applicable to VBA.
Note that the More Information section has more specific details for the devs.
Tony Toews, Microsoft Access MVP
Msiza
Robert A. Swirsky
I found the following procedure to work for Excel VBA:
1. Download the VB6MouseWheel.exe package
2. Extract in a directory.
3. Register VB6IDEMouseWheelAddin.dll using regsvr32
4. Run regedit (the registry editor) and File->Import the file "VBA Mouse Wheel Fix.reg".
5. Open Excel, then the VBA editor, then Add-Ins->Add-In Manager. The "Mousewheel Fix" entry should be in place. Toggle-on both Load Behavior options (Loaded/Unloaded and Load on startup).
Hope this helps.
SSSchultz
I have a client that had this issue on their previous version of MS Office (2000). We have since upgraded the product to 2003 and had hopes that the issue would be resolved. Looks like it has not yet been resolved. They too have a long filtered form and when they scroll the current record changes. My resolution will have to be to re-do the page with tabs or something - so that the end user doesn't have to scroll at all. This is an application written by another developer that I am supporting - a re-write was not my expectation, however, it's the only way around this. We do not want to use any work arounds.
I just wanted you to know that this issue still exists.
Thanks
Deepak Makhija
After reading your posts, I forwarded your comments to a team that evaluates product feedback and redirects it to the appropriate team. The engineer would like some additional details so that he can more thoroughly evaluate this issue.
You mentioned that VBA doesn’t support mouse wheel scroll. Do you mean that VBA doesn’t support the mouse wheel scroll event or that the VBA window doesn’t support the mouse wheel scroll. If possible, please provide the steps to repro this issue and let us know what kind of impact this has on your business.
thanks,
-brenda (ISV Buddy Team)
anderskj1
I can confirm this works in VBA for Access 2003 too. Thanks GKNewYork.
RichardGodin
Jefy Dominic
http://support.microsoft.com/ id=837910
He also sent a request to MSWISH@microsoft.com in hopes that they will fix it in the next version.
I hope this helps,
-brenda (ISV Buddy Team)
Harald Mejlholm
This is something that ought to be fixed. In fact it ought to have been fixed some time ago.
I hope that whoever is responsible for fixing this problem will give it high priority.
Andrew Watt
MVP - InfoPath
suddenelfilio
Those are work arounds not fixes. Does method 1 work in VBA Method 2 means installing a three year old version of a mouse driver.
It's also my understanding that MSWISH has been deprecated.
Finally I was told, by Microsoft personnel, the VBA IDE development team visits this forum. And that this would be a good place to bring this issue to their attention.