Peter Thorntons ComboBox mouse wheel scroll

For anyone not familiar with this, it allows you to use the mouse scroll wheel in a userform and the full code can be viewed here

I know it works in a userform, however I'm trying to use it for an ActiveX ComboBox.

I've set it to trigger as:

Please Login or Register  to view this content.

However I'm getting a
Run-time error '438':
Object doesn't support this property or method

Does it simply not work outside a userform or is it something I've done wrong with the syntax here:

Please Login or Register  to view this content.

as needs to be the format of
HookListBoxScroll(frm As Object, Ctl As MSforms.control)

I'll never take the scroll wheel for granted again!

Link to full code is in initial post (the word here).

I'll put the link as the full URL below:

https://social.msdn.microsoft.com/Fo...0?forum=isvvba

The workbook is huge and contains lots of sensitive information but I'll create an example workbook to illustrate what I'm doing.

In the meantime, the code I'm using is:

Please Login or Register  to view this content.

All I wish to do is be able to use the mouse wheel to scroll through the combobox list - instead of the worksheet.


Here's the example:

Hi BuZZarD73,

Have you, or perhaps someone else here, manged to apply this code to a dropdown validation list, without using the userforms?

From the example's I've reviewed, and taking a hint from the blog title from which this code orginated, "Mouse scroll in UserForm ListBox in Excel 2010".
I suspect the source code is hardwired for just "User forms"

But if someone else has found a way around this then please share I'll also check other potential sources and provide feed back.

Being an old thread, and my first post, we'll see how we go.

It won't work with a data validation dropdown because that's not a windowed control, as far as I know.

It is my understanding that both Active X ListBox and ComboBox commands are able to be interfaced with Peter'a code, but I am having this confirmed!

There's also code availble,provided by Jaafar Tribak and posted in a forum titled "Re: How to get handle to a control on a spreadsheet? ", which does allow a mouse scroll interface with ActiveX listBoxs controls.
This code does appear to be based on Peters, but as I havn't been unable to make contatc with Jaafar to discuss His code, I a still waiting for clarification on combobox mouse scrolling.

However, I am doing my best to push forward some clarification son Peter's code and to hopefully post back some working examples

Yes it will work with Activex controls on a sheet, but you asked about validation drop down which aren't Activex.

Yes, My Bad