Listbox Scroll

MSingh
3StarLounger
Posts: 366
Joined: 12 May 2010, 06:49

Listbox Scroll

Post by MSingh »

Hi,

How can i scroll in userform Listbox1 using the mouse wheel?
Listbox1 does have the vertical scrollbar but it would be ideal if i could scroll with the mouse wheel.

If there is a solution, would it also work for Listbox2 embedded in sheet5 ?

Thanks again
Mohamed

User avatar
HansV
Administrator
Posts: 78391
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Listbox Scroll

Post by HansV »

It is possible using lots of Windows API code, but it is very tricky - when I tried it, my version of Excel froze completely. So I strongly recommend NOT trying it.
Best wishes,
Hans

MSingh
3StarLounger
Posts: 366
Joined: 12 May 2010, 06:49

Re: Listbox Scroll

Post by MSingh »

Thanks Hans,

I read the same about excel crashing.
I'll take your advice & leave it out.

Kind Regards
Mohamed