use of scroll wheel in combobox

[Excelerate-nl]

Hello experts,

Does anyone know why the scroll wheel of my mouse does not have any effect
when attempting to scroll in a combobox list?? Is there a way to change
settings or use different style combobox???

Thanks,

Jan Bart

 

[Robin Hammond]

Jan,

The wheel is not natively supported in VBA.

There's a solution here that works for listboxes that can be adapted for
combos:

http://www.enhanceddatasystems.com/ED/Pages/ExcelListScrolls.htm

Please post back and let me know if it works.

Robin Hammond
www.enhanceddatasystems.com

 

[Excelerate-nl]

Dear Robin,

The code looks impressive for such a standard action within Windows.
For the moment I will not use the Beta in the solution I am writing for my
customers. I will try it later and actually hope for a more simple
solution....

It is surely a lack of service of MS that VBA does not support this wheel
action.

Thanks for your reply.

Regards,

Jan Bart