I would like to use the code RoryA posted in the thread "Code for mouse wheel in VBA" but I'm not sure what to do in order to suit my need;
track the mouse wheel movements up and down in order to update a row counter I have in a cell of a sheet.
Instead of a userform I have an Excel 2016 Sheet on a Windows 10 machine.
I don't want to take complete control of the mouse, just get a parameter (boolean or whatever) which tells me if the wheel has been moved up or down and then update the cell row counter (3 rows per movement are the default I think) every time the wheel is moved and leave all the rest to Excel. Is it possible?
Thank you for your time!
track the mouse wheel movements up and down in order to update a row counter I have in a cell of a sheet.
Instead of a userform I have an Excel 2016 Sheet on a Windows 10 machine.
I don't want to take complete control of the mouse, just get a parameter (boolean or whatever) which tells me if the wheel has been moved up or down and then update the cell row counter (3 rows per movement are the default I think) every time the wheel is moved and leave all the rest to Excel. Is it possible?
Thank you for your time!
