Mouse wheel scroll through ComboBox dropdown.

[dagda13]

Hi,

I'm using Excel 2016 64-bit and have a ComboBox with a dropdown that contains 150+ lines. I'm trying to set it up so that I can scroll through the lines with the mouse wheel.

 

[sijpie]

See here.
https://www.mrexcel.com/forum/excel...wheel-scroll-userform-all-its-controls-2.html
Look for the post by Jafaar Tribak

 

[BlueAure]

See here.
https://www.mrexcel.com/forum/excel...wheel-scroll-userform-all-its-controls-2.html
Look for the post by Jafaar Tribak

I've been looking for a better solution to this problem. Jafaar's solution works, however I've had some problems with it. Occasionally, if it has control of a scroll wheel and Excel loses focus, it will keep your scroll wheel trapped in that combobox. This means it is impossible to scroll anything else. I wasn't able to find any alternative for that code though. It will probably be fine for dagda's use case, but if anyone is switching windows there can be problems.

 

[sijpie]

I have somewhere in my projects a different solution, I think. But at the moment no time to dig it up. See what I can do. But I am also sure that works for Office 32, no idea about Office 64

 

[Per_]

Open and old thread, Sijpie, did you find any better solution? I got the same problem as BlueAure

 

[sijpie]

I used code by Peter Thornton. It sometimes has issues. Here is a thread that discusses improvements on the code and how to make it work on 64bits PCs as well.

because it uses hooks into the windows system I think it will always be a bit haphazard.

Scroll Wheel mouse on a userform frame [SOLVED]

Hi guys, I´m tying to be able to scroll up down with my mouse on a frame inside a userform, but so far I was not able to make it work, I´ve searched and I came across this code, which I will paste below, changed the name of the userform, also the name of the frame on the userform module...

www.excelforum.com

 

[Jaafar Tribak]

We discussed this topic recently in this thread :

ComboBox Scroll with Mouse wheel

i tried to work with peter Peter Thornton (Excel MVP 2008-13) code which works amazing for userform Comboxes and listboxes but im a vba noobie and i cant seem to understand how to make this code work for a regular ComboBox on a worksheet Module Code: 'Enables mouse wheel scrolling in controls...

www.mrexcel.com

The code doesn't use a Windows hook so it is stable and won't crash excel.

 

[Per_]

Ok. So you do not know any code that will work stable on a worksheet?

 

[Jaafar Tribak]

Ok. So you do not know any code that will work stable on a worksheet?

Sorry what do you mean ?
The code in the link is stable but it is designed for comboboxes on userforms not for comboboxes embeeded in worksheets.

 

[Tom.Jones]

Excellent job Jaafar!!!!

(Office 365 64 bit)