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 - https://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