Activating mouse scroll wheel in listbox

[ccRider246]

I have a listbox on a userform that is quite long. A vertical scroll bar is visible for scrolling down the list. I would like to be able to code this so that a mouse wheel will activate the scroll bar. Does anyone if that can be done?

Excel 2003 - Windows XP

Thanks,

Chris

[Jan Karel Pieterse]

It can be done, but is not very stable, see:

http://www.eggheadcafe.com/forumarchives/VisualBasicwinapi/Jun2005/post23414144.asp

[Bob Phillips]

What about http://www.gasanov.net/VBScroll.asp

[ccRider246]

It can be done, but is not very stable, see:

http://www.eggheadcafe.com/forumarchives/VisualBasicwinapi/Jun2005/post23414144.asp

Thanks, Jan. I have a modal form so I am going to give this a shot. If it works for me I will mark this solved.

Chris

[Jan Karel Pieterse]

xld: a great tool to scroll your code window, but it does not scroll my listboxes on userforms.

[ccRider246]

What about http://www.gasanov.net/VBScroll.asp

I will check this out but on the surface it looks like it is designed to make the mouse wheel functional in the VBE. I need it functional in the userform listbox, not the VBE. But thank you, I will check it out.

Chris

[Bob Phillips]

ACtually, I meant the Mabry ActiveX control, I gave the wrong URL, but it seems that site is not up any longer.

[floraburris]

A fantastic tool for scrolling your code window, however it does not scroll my userform listboxes.