Page 1 of 3 123 LastLast
Results 1 to 15 of 34
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Wow! When did the first mouse wheel appear? The first IntelliMouse with scroll wheel is from 1996, so it only took them 8 years...

  2. #2
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Hi, just wanted to say a <big><font color=red><font face="Snap ITC">THANKYOU!! </font face=snap></font color=red></big> for this post as it not only showed me how to sort out an (age old) problem - ie. scrolling in the VBE, but also along the way it showed me about compiling a .dll etc.!
    The education continues, and my VBA now scrolls, what a satisifying day!!

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

    Woody's Lounge - Solid man. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Thanks,

    pmatz

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Thanks a lot !!

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    I haven't got VB6 installed, could anyone post the VBE dll here with some instructions on how to install?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Thanks Hans.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Glad this helped - I use an MS mouse at home (scroll wheel has always worked in VB Editor) but Logitech at work (scroll wheel did not work). While at work, I'd always being scrolling mouse wheel out of habit (like a dummy) in VBE and of course nothing would happen. This was always a MAJOR annoyance. I'm glad MS published a fix (at long last) but as HansV noted, mousewheels have been around a long time, you'd think Microsoft, with its armies of allegedly brilliant developers, would have fixed this in the first place - apparently a simple window hook procedure solves problem... anyway better late than never.... <img src=/S/mice.gif border=0 alt=mice width=50 height=25>

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    I use an MS mouse at work which worked intermittently at best with scrolling in the IDE (VB or VBA) but now it appears to work flawlessly so a big thanks to you! <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    Wonderful that Access developers have to contrive ways to disable the scrollwheel in forms while trying to re-enable it in other apps! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Hans,

    Thanks for posting the VBA version, I no longer have to feel stupid when I go into the VBA editor and use the scroll wheel out of force of habit.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Only those who want to use the blasted thing! I make every effort to avoid it. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  10. #10
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Mark

    Definately a star post.

    I've installed both versions, thanks Hans.

  11. #11
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Mousewheel in IDE Update (VB 6, VBA 6.0)

    An update to an issue that was never resolved satisfactorily in several previous threads: Mousewheel not functioning in the VB or VBA IDE. Microsoft has finally seen fit to provide an explanation, and better yet, a solution to this annoyance, that does NOT involve having to buy one of their optical mice or installing the MS optical mouse drivers. See MSKB article 837910:

    Mouse wheel events do not work in the Visual Basic 6.0 IDE

    According to article, cause of problem is: "Mouse wheel support in Visual Basic 6.0 is a function of the mouse driver. The WM_MOUSEWHEEL message is sent to the Focus window when you rotate the mouse wheel. Because the Visual Basic 6.0 IDE does not have built-in support for scrolling by using the mouse wheel, the IDE ignores the WM_MOUSEWHEEL message." To fix problem w/o having to install the MS Intellipoint drivers, article provides a link to download a compiled ActiveX .DLL you can register on your system, along with the VB6 project files with source code, in case you want to compile your own version of the project. Note that the .DLL provided by MS only works in VB6 IDE, not the VBA VB Editor IDE. To enable the mousewheel in VBA, make copy of project files, open project in VB6, double-click the Addin Designer module (Connect.Dsr). In Addin Designer dialog's "Application" list, select "Visual Basic for Applications IDE" instead of "Visual Basic", modify description, etc, as desired to reflect VBA vice VB. Save project, then compile as new .DLL ("Make..." on File menu). The new component will automatically be registered on your system. If distributing to other machines, register using regsvr32.exe as described in MSKB article. You should see "Mousewheel Fix" listed in the VBE Add-in Manager (as designed loads automatically on startup). I tested this on my system at work (WIN 2K, Office 2K, VBA 6.0) where I use Logitech optical mouse, and where mouse wheel has never functioned in VBA VB Editor, and I can now scroll away with impunity in code modules.... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Note the code itself (Main.bas module), which works by hooking the mousewheel messages, requires no modification, as both VB and VBA IDE's use same Windows class ("wndclass_desked_gsk") and both include "Microsoft Visual Basic" in the Windows caption.

    HTH

  12. #12
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Aagghh! It doesn't work for me, what am I doing wrong? Yes I get scrolling but its almost uncontrollable. Scrolling doesn't stop when I want it to and I can wait for ages whilst my code scolls past where I wanted to stop. Worse, my natural reaction is to scroll the other way, so when the first scrolling finishes my code then scrolls back past where I started.

    It seems that instead of scrolling stopping when I release the mouse, I've 'dialed in' a set amount of scrolling. And its so slow.

    How do I rid myself of this dll?

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    The VB code window by default ignores the mouse wheel event. The DLL makes the VB code window "aware" of this event. The mouse wheel then should work the same way as in other applications. You can set some of its behavior in the Mouse control panel, for example the number of lines to scroll with a single notch of the mouse wheel.
    You can turn off the add-in by selecting Add-In | Add-In Manager, and clearing both check boxes for the MouseWheel Fix.

  14. #14
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    Hi Hans

    The mousewheel DOES NOT work for me the same in the VBE as it does in other apps. If I scroll here in the lounge the screen scrolls; when I stop moving the mousewheel the scrolling stops. It's virtually instant. Within the VBE if I move the mousewheel 10 clicks (set at 3 lines per click) it will scroll 30 lines and won't stop until it has completed them.

    Thanks for the 'how to' get rid of.

  15. #15
    Star Lounger
    Join Date
    Jan 2001
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mousewheel in IDE Update (VB 6, VBA 6.0)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    I like the idea, but if you split a code window horizontally, the mouse wheel makes both panes scroll.
    I found an alternative here: http://www.gasanov.net/VBScroll.htm, which scrolls only the active pane,
    and also has some other interesting settings.

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •