Scroll Wheel, Excel and VBE Weirdness
 

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

-------------------------
If toast always lands butter-side down, and cats always land on their feet,
what happen if you strap toast on the back of a cat and drop it?
Steven Wright (1955 - )

Scroll Wheel, Excel and VBE Weirdness
 

In case it's relevant:

Excel 2003 (11.8211.8210) SP3

VBA 6.5.1024

Scroll Wheel, Excel and VBE Weirdness
 

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!

Scroll Wheel, Excel and VBE Weirdness
 

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

"egun" wrote in message
...
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

-------------------------
If toast always lands butter-side down, and cats always land on their
feet,
what happen if you strap toast on the back of a cat and drop it?
Steven Wright (1955 - )

Scroll Wheel, Excel and VBE Weirdness
 

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.

"Rick Rothstein (MVP - VB)" wrote:

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

"egun" wrote in message
...
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

-------------------------
If toast always lands butter-side down, and cats always land on their
feet,
what happen if you strap toast on the back of a cat and drop it?
Steven Wright (1955 - )

Scroll Wheel, Excel and VBE Weirdness
 

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

"Rick Rothstein (MVP - VB)" wrote:

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

"egun" wrote in message
...
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

-------------------------
If toast always lands butter-side down, and cats always land on their
feet,
what happen if you strap toast on the back of a cat and drop it?
Steven Wright (1955 - )

Scroll Wheel, Excel and VBE Weirdness
 

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

--
Jim
"egun" wrote in message
...
| 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!
|
|