how to get Mouse Scroll Wheel working in a Frame with a vertical scrollbar contained in a user form

[ttt123]

hello,

I have a Userform with a main frame in it that has a vertical scrollbar. The problem is that when using the scroll wheel button on the mouse, it doesn't scroll up or down the frame. I have to drag the bar up and down or use the arrow keys.

I have used other controls such as TreeView where the mouse scroll wheel worked, but it doesn't seem to work with a Frame.

Are there any workarounds to this, perhaps an API based solution?

Thanks,
Taylour

 

[ttt123]

found the solution here: http://www.mrexcel.com/forum/showthread.php?t=154823

I used the solution in the final post and updated it to use Frames instead of ListBoxes (use .ScrollTop instead of .TopIndex)