VBA Help to Scroll with Wheel Mouse in ListBox

[Phixtit]

How do I setup the ListBox Properties to Scroll Up & Down through List with Wheel Mouse?

 

[rs2k]

I found this link, don't know if it will help;

http://www.xtremevbtalk.com/archive/index.php/t-178071.html

Colin

 

[Phixtit]

Solved!

Thanks for a point in the right direction.
I tried the example there but it kept freezing excel.

I then figured it out & HERE is a working example.

 

[Jeffrey Smith]

Phixtit: Your link needs a user to sign in before viewing postings. Can you post the solution here?

 

[RoryA]

Why not just register there - it doesn't cost anything, and avoids any issues with simply nicking code.

 

[MyronJames]

GROUPSDLG won't compile in MS Excel 2010 VBA. Is there a Reference I need to select? or something else I need to do?

 

[RoryA]

GROUPSDLG is the name of the userform where the listbox is.

 

[wintermelon]

Hi, I know this is a old thread but I am trying to do the same right now with Excel 2010.
I tried the code posted by Phixtit, it still has bouts of freezing, and it has this quirk where the scrolling doesn't work immediately after the userform loads even though the form/listbox seems to have the focus.
I will have to click once on the userform/listbox, click once on a cell in Excel, then click once on the userform/listbox, before the scrolling can work.
Has anyone encountered the same issues and have workarounds/solutions?

Thanks!

 

[MyronJames]

I gave up on it. However, another option is to Left-Click on a line while holding down that button and Drag the mouse arrow upwards or downwards and the records will scroll.

 

[wintermelon]

Thanks MyronJames. I found a thread with sample code that is working very well. Link here. There is also another thread with code if the listbox is in a worksheet rather than in a user form. Link here.
Hope this helps others who have stumbled on this thread looking for the solution.