Mouse scroll on a listbox

[luizmachado]

I'm using this code from Peter Thornton which enables me to scroll in a userform listbox, but every time my mouse goes through the listbox (just moving the cursor to another part of the userform, without even clicking) it "activates" the listbox. Is there any way I can "block" this to happen? I mean, any way that the mouse scroll works only when I click on that down arrow to open the listbox?

Ps: and I guess it only works for Windows. If this is right, how can I make it to work with Mac's os also?

This is Peter Thronton's code:

Please Login or Register  to view this content.

This is my workbook, if needed:

[LJMetzger]

All the API functions you are using 'Private Declare ...' etc. are 32 bit Windows dependent. New versions of the function calls are needed for 64 bit Windows.

The API calls do not work on the Mac. According to Jaslake in post #2 of the following thread, you may have success if you use a 3rd party Virtual Windows machine on your Mac: http://www.excelforum.com/excel-prog...el-2011-a.html

Lewis

[luizmachado]

Hmm, got it. But how do I solve that problem? I mean, not this mac/windows problem, but moving cursor through the listbox and it doesn't activate one.

All the API functions you are using 'Private Declare ...' etc. are 32 bit Windows dependent. New versions of the function calls are needed for 64 bit Windows.

The API calls do not work on the Mac. According to Jaslake in post #2 of the following thread, you may have success if you use a 3rd party Virtual Windows machine on your Mac: http://www.excelforum.com/excel-prog...el-2011-a.html

Lewis

[Izandol]

Control must be active for code to obtain window handle and this hook code is called from mousemove event. Perhaps you may try dropbuttonclick event instead.

[LJMetzger]

A while back I was able to get Peter Thornton's code to work with a great deal of help from several people. The files associated with Post #10 in the following thread may help you: http://www.excelforum.com/excel-prog...orm-frame.html

Lewis

[luizmachado]

A while back I was able to get Peter Thornton's code to work with a great deal of help from several people. The files associated with Post #10 in the following thread may help you: http://www.excelforum.com/excel-prog...orm-frame.html

Lewis

Thank you!!! It worked.