Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

scroll a long validation dropdown list

0

Is there a way to scroll a long validation dropdown list with the mouse wheel ?

Regards 

Answer
Discuss

Answers

1
Selected Answer

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.

Discuss

Discussion

Thank you for your answer,
my dropdown list is over 200 lins, so the PageUp PageDown Home End sounds like a good idea, 
but i find this Solution to scroll and it was very helpful for me
https://www.mrexcel.com/forum/excel-questions/411578-mousewheel-scroll-long-cell-validation-dopdown-lists.html

JAExcel (rep: 10) Jul 10, '17 at 3:24 pm
I saw that thread and that is actually what I was referring to when I said that there are some rather involved programming ways to achieve this.

Be carful with that solution as it seems to cause issues in some systems, such as crashing.

If Excel starts to act up and you can't figure out why, try disabling this macro first when troubleshooting the issue.
don (rep: 1989) Jul 13, '17 at 2:35 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login