This ranks right at the top of annoyances when it comes to working with the VBA IDE – the mouse scroll wheel simply does not work. So if you have more lines of code than can fit into a single screen in the VBA IDE, you end up having to drag the scroll bar to up/down to navigate. Jimmy Peña recently posted this very useful VBA tip on his informative blog that provides the solution to this issue. (Read more about this at microsoft help.)
It took me a bit of a time to get this right especially adding the addin to DLL registry server. Here is a stepwise tutorial on how you can make the mouse scroll wheel work with the VBA IDE:
1. Download the vb6mousewheel.exe from the microsoft site and save to local drive.
2. Once the download is complete, double click on the exe. Click on Ok when the end user agreement message appears.
4. Copy the file VB6IDEMouseWheelAddin.dll to a stable location. I used D:\Program Files\Microsoft Office\OFFICE11 which is one of the program folders used by MS-Office and which I am sure I am not likely to delete in a hurry.
6. We will now need to register the the DLL (that we copied to the office folder earlier) with windows. In the command line, move to the folder where the VB6IDEMouseWheelAddin.dll has been copied.
7. When you reach the folder where the file has been copied, enter the following:
8. We will now add the DLL’s information to the windows registry. Go back the folder where we extracted all the files in point 3 above. Double click on the VBA Mouse Wheel Fix.reg. This will add the information to the windows registry. Click Yes when prompted for “Are you sure that you want to add the information in~” message box. Once you’ve done that you will get the following confirmatory message.
9. The only step that needs to be carried out now if to go ahead and add the DLL as an addin the VBA Editor (IDE). Open a blank excel sheet and open the VBA editor. On the menubar, click “Add-Ins” -> “Add-In Manager”.