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.

 

[2Took]

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.

Can you make it for comboboxes imbedded in worksheets?

 

[sijpie]

possibly for active-x combobox. But i hardly ever use controls in a worksheet, so wouldn't know how to do it.