Mousewheel-Scrolling in UserForm

**Edwood** · 11-17-2009, 04:31 AM

Hi,

i want to know whether there is any way to make an MouseWheel-Event in VBA (Excel 2003) and send it to the scrollBars of my UserForm?

**Edwood** · 11-17-2009, 05:19 AM

ok i found a solution myself. I just bind the ScrollTop-Property to a slider-control (Scroll-Event). This Slider-Control gets the Focus when clicking on the UserForm. Not an elegant solution - But it does the job

**broro183** · 11-17-2009, 07:16 AM

hi Edwood,

Welcome to the Forum

Thanks for posting your solution. Can you please mark the post as solved (instructions are on the Rules page)?

Rob

**romperstomper** · 11-17-2009, 09:25 AM

You can do it without a slider if you use API functions. See attached demo.

**ysehgal** · 01-31-2012, 02:43 AM

Can you please attach an excel file with the solution you have posted...

Thank you

Originally Posted by Edwood

ok i found a solution myself. I just bind the ScrollTop-Property to a slider-control (Scroll-Event). This Slider-Control gets the Focus when clicking on the UserForm. Not an elegant solution - But it does the job

**pike** · 01-31-2012, 05:16 AM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.