Scroll Wheel, Excel and VBE Weirdness

[egun]

I've been working on a new Excel utility in VBA lately, and I've noticed a
strange thing happening while working in Excel and the VB Editor. Once in a
while, after I've run the macros I'm testing, if I try to use the scroll
wheel on my Logitech mouse while Excel is the active widow, I immediately get
switched to the VB Editor window and start scrolling through my source code
window instead. It's pretty annoying!

The utility I'm developing (which compares sets of data, sort of like
Windiff) puts up a dialog box to get user input options, and then hides the
dialog box and runs the comparison code.

Anyone have a clue as to why that's happening, and what to do to prevent it?
The only way I have found is to quit and restart Excel.

Thanks,

Eric

 

[egun]

In case it's relevant:

Excel 2003 (11.8211.8210) SP3

VBA 6.5.1024

 

[egun]

And one more clue:

If this is happening, and I close the VB Editor window, and then try the
scroll wheel in Excel, Excel scrolls the window for exactly one "click" of
the scroll wheel, and then the window loses focus!

 

[Rick Rothstein \(MVP - VB\)]

Unfortunately, I do not have a solution for you... I just wanted to mention
that the same thing happens to me with my Logitech mouse (G7) and I also
find it quite annoying. I have not been able to determine exactly what
triggers the problem. I presume there is something wrong with Logitech's
mouse driver; although I guess, theoretically, it could be a problem with
Excel's code and how it processes the scroll wheel event.

Rick

 

[JLGWhiz]

I think you have it fault isolated Rick. I have a Logitech HID compliant and
in the Excel window it increases or decreases the font size while in the code
window it scrolls. However, I have it set to scroll 1 line and it is
scrolling three. So it looks like the driver for the wheel is not really set
for Excel. As far as I know, it works OK in text applications like Notebook
and Word.

 

[JLGWhiz]

I said font size, it should have been zoom ratio.

 

[Jim Rech]

I went back to an MS driver because of this. Lost some Logitech buttons as
a result

--
Jim
| And one more clue:
|
| If this is happening, and I close the VB Editor window, and then try the
| scroll wheel in Excel, Excel scrolls the window for exactly one "click" of
| the scroll wheel, and then the window loses focus!
|
|