Make Mouse Scroll Wheel Work in VBA Editor (IDE)

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.

3. Extract the files to a local folder.


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.

5. Now press Win + R (The windows key on the keyboard + r) OR Click “Start” -> “Run”. In the box type “cmd” and press enter.

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:
regsvr32 VB6IDEMouseWheelAddin.dll

You will get the following message:

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”.

In the Add-In box that appears, turn on both the “Loaded/Unloaded” and “Load on Startup” checkbox. Press Ok.

That’s about it. You code in the VBA Editor (IDE) should now be scrolling

What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Comments and Trackbacks

  1. Jon Peltier wrote:

    There are numerous small utilities that do the same. One which is easy to use and has a much smaller footprint than the one cited above is VB Scroll:

  2. Deepak Shakya wrote:

    Thanks for this awesome help. My mouse not scrolling in the VBA window was just bugging me.. Thanks to you it solved the problem.

  3. Ajay wrote:

    Glad this was of help. Welcome to da TaB !

  4. Saravanan wrote:

    This made my life so easy as I am mostly involved in creating macros in Excel…

    Thanks for the help…

  5. Ajay wrote:

    Glad this was of help and welcome to da TaB !

  6. Miron wrote:

    You are awesome! Thanks heaps

  7. Ajay wrote:

    Thanks Miron and welcome to da TaB !

  8. xlnt wrote:

    Very helpful, fedup without this option.
    Thanks a bunch 🙂

  1. VBA Tips, Tricks and Best Practices, Part Two of Four » Code For Excel And Outlook Blog wrote:

    […] [Update 7/14]: Ajay from posted a neat tutorial showing how to install the mouse wheel fix. […]

  2. links for 2009-09-01 | the markfr ditherings wrote:

    […] Make Mouse Scroll Wheel Work in VBA Editor (IDE) | da TaB is On (tags: excel vbe fixes) […]


Chinese (Simplified)DutchEnglishFilipinoFrenchGermanHebrewHindiItalianJapanesePortugueseRussianSpanish

treeemap software for excel