Is there a way to scroll a long validation dropdown list with the mouse wheel ?
Regards
Is there a way to scroll a long validation dropdown list with the mouse wheel ?
Regards
What an annoying problem that I never thought of.... I'm on a laptop so I don't know about the scroll-wheel of a mouse, but there is a simple way to do it using the keyboard.
You can select the cell and hit PageUp PageDown Home End or use the arrow keys UpArrow or DownArrow.
You can also see the drop down list without clicking once you select the cell by hitting Alt + DownArrow
I have seen rather invovled methods of using programming to make the list move with the scroll-wheel, but none of those ways seemed to be very reliable.