Yotzo Level: Protégé
 Registered: 06-08-2005 Posts: 4
|
Mouse wheel problem in Excel 2k3 VBA
Hello!
I'm trying to use mouse wheel in excel 2k3 VB macro, under windows XP. I found the code at http://www.andreavb.com/tip060008.html, but I just can't see any event related to wheel.
To see what's happening i put a "UserForm1.Label1.Caption = lMsg" trace line before the "If lMsg = WM_MOUSEWHEEL Then" line, where I print lMsg, but it's never changing when I rolling the wheel.
It's only changing, when I click to the task bar or back to the application window.
I don't know if I'm missing something, or this code shouldn't ever work
under office 2k3/windows XP, so it would be really great to me, if someone
could tell me what could be wrong.
Many thanks:
Yotzo
|