OxfordCurmudgeon
New Member
- Joined
- Oct 24, 2023
- Messages
- 14
- Office Version
- 2010
- 2003 or older
- Platform
- Windows
When developing code, I jump back and forth between the VBA and normal Excel windows. Under a set of circumstances that I have yet to narrow down, when I'm looking at the Excel workbook, using the scroll wheel jumps me back to the Visual Basic window.
If I close the workbook and re-open it, the mouse wheel works as expected: I can scroll in the Excel or VBA windows.
In the VBA window, pressing F8 highlights the selected SUB line in yellow. The mouse wheel continues to work as expected. Pressing F8 again executes the first line of code; the mouse wheel works as expected (in both VBA and Excel windows). The next line is an ON ERROR statement. Single-stepping through that doesn't affect the mouse wheel operation. And so it goes. I can go through a normal debugging process without any problems -- and then the problem pops up. I haven't isolated a pattern.
Any insights?
If I close the workbook and re-open it, the mouse wheel works as expected: I can scroll in the Excel or VBA windows.
In the VBA window, pressing F8 highlights the selected SUB line in yellow. The mouse wheel continues to work as expected. Pressing F8 again executes the first line of code; the mouse wheel works as expected (in both VBA and Excel windows). The next line is an ON ERROR statement. Single-stepping through that doesn't affect the mouse wheel operation. And so it goes. I can go through a normal debugging process without any problems -- and then the problem pops up. I haven't isolated a pattern.
Any insights?
