This is not homework; I am 56. I program only for myself and the fun of it. I'm willing to pay if I can't do it on my own and can't find a solution in another way.
I originally posted this help request, my first, on the free section of the site but haven't gotten any bites so I'm trying this out.
This is my original post:
I need to capture mouse wheel rotation steps in order to update a row counter in a cell of a sheet.
I don't need to take complete control of the mouse (unless I have to), just read a parameter which tells me if the wheel has been moved up or down.
I have Excel 2016 and Windows 10.
Is it possible to do what I need? Does anyone have the VBA code to achieve it? (and a quick explanation of it, thanx)
I was asked for more information, here it is:
I'd like to be able to update a cell of a sheet where I have a row counter.
By using Application.OnKey I already update that cell when the user presses PgUp/Dn and the Up/Down arrows by subtracting/adding 33 (it is the number of rows I show in a page) or 1 for the arrows. I'd like to do the same with the mouse wheel by adding or subtracting 3 (better yet the number in Settings/Mouse).
I've seen code which lets the user scroll in a form but, because I'm a beginner, I understand little of that code therefore I can't change it.
That's it.
I'd add I have 32bit Windows 10 on a 64bit machine; one day I guess I'll upgrade to Windows 10 64 bit but for now....
My requests, obiously except the code :
1. a comment to explain what each function/sub does.
2. where the code has to be put (Sheet, Module, ThisWorkBook).
3. changes to be made if I upgrade to 64bit Windows 10.
4. how to start the code; if possible i'd like to enable and disable it (which is, return the wheel to its normal use) by pressing for example an ActiveX button.
Any further info/clarification required please ask.
Thank you!
Guido