I have just converted to office 2010 from 2003, and really miss the possibility to mouse scroll while in formula editing mode in excel (after hitting F2). So what I want is to use vba code to capture the event of a mouse scroll while in editing mode, and translate this into a page scroll.
I don't know if this is possible as I am fairly new to events within vba, but I was wondering if someone might have any good suggestions to where to begin.
Thanks in advance!
Unfortunately, you can't run any VBA code while you're in editing mode, so you can't capture mouse events in that situation.
You can scroll with the mouse wheel when you're editing a formula directly in a cell (i.e. after pressing F2, if you have ticked the check box "Allow editing directly in cells" in File > Options > Advanced), but not when you're editing a formula in the formula bar.
Regards, Hans Vogelaar