Mousewheel in IDE Update (VB 6, VBA 6.0)

[MarkD]

That's interesting to note - I've never noticed this, probably because I've never found any use for a "Split" window, in VB IDE or elsewhere (like Excel) where this option is available....

[rgrosz]

Mark, you've really missed out. For cutting and pasting (VBA code, Word documents, etc.), the "Split" window is Da Bomb!

[Ruff_Hi]

Huge Thank-you <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15> I originally saw this post and assumed it was talking about how to VB respond to the wheel, not how to get the wheel to drive the VB screens. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

[joelfinkle]

I installed this, and initially loved it, but then noticed a lot of crashiness in Word shortly thereafter, usually while mousewheeling in the VBEditor.
Some of the crashes don't even display the typical MS "Oops" dialog -- application just plain closes! Lost some good work this way, and I've turned it off. Now I'm tryinig to figure out how to excise it all together.

It's possible it's an interaction with one of my other add-ins in Word: RoboHelp, Acrobat and Reference Manager are all loaded. I've got a couple of the Office Developer add-ins too, but none of them are currently turned on.

Anyone else see this happen?

[HansV]

It might be interaction, although I wouldn't expect those add-ins to interfere with the Visual Basic Editor.

I have been using the mouse wheel in the VBE intensively since I installed the add-in a month ago, and I haven't noticed any negative effect.

[Andrew77]

Hello all,

Came across the following while trying to find a way to get the scroll wheel to work in FrameMaker. As a bonus, it makes the scroll wheel work in the VBA IDE as well, and offers a few extra bells and whistles. Freeware.

http://www.geocities.com/SiliconVall...freewheel.html

Enjoy!

[reimer]

Hans,
I tried to install and it fails with error code 0xB0004005. I have Excel 97, so maybe it does not have VBA 6(?). Is there anything I can do to get the scroll wheel working in VBA?

Thanks,
Chuck

[charlotte]

Office 97 was built on VB5 and as I recall there was no built in scroll wheel support in that version. Even in VBA6 (Office 2000 and above), support for the scroll in the IDE only comes with the recent patch.

[reimer]

Charlotte,
Thank you kindly for the speedy reply. I will wait til I can get upgraded at work.
Chuck

[HansV]

Chuck,

The VBA in Office 2000 and up is based on VB6, while the VBA in Office 97 is based on VB5.

The DLL I attached has been compiled for the Visual Basic Editor in Office 2000 and up. The VB6 compiler I am using does not provide an option to create a DLL for the Visual Basic Editor in Office 97, so I'm afraid I can't help you. Sorry.

[HansV]

Edited by HansV to replace attachment that was lost in server crash

The attached zip file contains the compiled DLL for the VBA editor (in Word, Excel etc.), named VBAIDEMouseWheelAddin.dll.
Unzip the DLL to a folder of your choice.
Select Start | Run...
Type <code>regsvr32 "CathVBAIDEMouseWheelAddin.dll"</code> (substitute the correct path) then press Enter.
That should install the add-in; open the Visual Basic Editor in any Office application to test.
You can turn the add-in on and off by selecting Add-Ins | Add-In Manager in the Visual Basic Editor.

[HansV]

Update: I didn't notice this before because I have the VBAIDEMouseWheelAddin.dll installed on all PCs I work on, but one of the Office updates during the second half of 2007 has enabled using the mouse wheel to scroll in the Visual Basic Editor in Office XP and 2003 (it was already enabled in Office 2007, and I don't know about Office 2000).

So VBAIDEMouseWheelAddin.dll isn't needed any more. If you installed it, you can turn it off in Add-Ins | Add-In Manager... in the Visual Basic Editor in any Office application (this will turn it off for all Office applications).
You can unregister the dll:
- Select Start | Run...
- Type the following, substituting the correct path of the dll:
<code>
regsvr32 /u "CathVBAIDEMouseWheelAddin.dll"
</code>
- Press Enter.
- If you wish, you can now delete the dll file.

[rory]

Doesn't work for me in XP, though I don't know if our IT department apply all the Office updates.

[StuartR]

Works for me in Office 2003 SP3 with all patches applied.

StuartR

[rory]

Does for me too at home using either 2002 or 2003. Must have been an update not applied at work (or maybe a mouse issue).