Mouse scroll in user form list

[GoDGo]

I have created a user form that includes a list box. The list box is large
and therefore produces a scroll bar. For some reason the the mouse wheel
does not work within this user form. The mouse wheel works perfectly
normally within the main active spreadsheet and the VBA code. I have
updated the mouse drivers (Microsoft Intellimouse Explorer) with no success.

Any clues would be great.

 

[Jim Rech]

It looks as if MS did not program the list box to respond to the wheel roll
event. I don't know that you can do anything about it.

--
Jim Rech
Excel MVP
|I have created a user form that includes a list box. The list box is large
| and therefore produces a scroll bar. For some reason the the mouse wheel
| does not work within this user form. The mouse wheel works perfectly
| normally within the main active spreadsheet and the VBA code. I have
| updated the mouse drivers (Microsoft Intellimouse Explorer) with no
success.
|
| Any clues would be great.
|
|

 

[Ivan F Moala]

You will Basically need to Subclass the Userform.

Have a look here for a technique to do this.

http://www.xtremevbtalk.com/showthread.php?p=812821#post79807

 

[Robin Hammond]

There's a solution on my site using a $29 activex control from mabry
software written by Karl Peterson I think and some mouse handlers I built to
get around the lack of handles for MSFORMS forms.

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

Robin Hammond
www.enhanceddatasystems.com