[转帖]如何在vba中使用鼠标滚轮

stone71

MouseWheel Fix for VBA

This is a followup to a previous blog entry of mine: Fix: VB6 IDE Scrolling using the MouseWheel.

Someone asked if my add-in would work within VBA for Office. I did some digging and yes it does. All you have to do is install the addin as described within:

Q837910 Mouse wheel events do not work in the Visual Basic 6.0 IDE - http://support.microsoft.com/?id=837910

Then create a .reg file with the contents below and merge it with your registry. Please note that Office (at least Word in my test) will ignore these keys if you put them under HKEY_LOCAL_MACHINE. It appears that add-ins for VBA are per user.

HTH

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\VBA\VBE\6.0\Addins\VB6IDEMouseWheelAddin.Connect] "FriendlyName"="MouseWheel Fix" "CommandLineSafe"=dword:00000000 "LoadBehavior"=dword:00000000

清风_ll

看起来不错,找个其它机子再试[em02]

chenjun

windowsXP+office2000验证正确，谢谢提供！

xiaog

XP＋XP，无此项，添加后运行Excel，打开VBE时“内存溢出”。

xiaog

或可用 Emily 斑竹提供的例子。

荒烟平楚

恩，我也来研究研究。