Excel Userform MouseWheel Scroll ComboBox DropDown List Issue

[MRJT]

There are several variations of code for MouseWheel Scroll for User Forms on different threads, but all of them that I have found has an issue with the combobox dropdown list when it is showing. When the combobox dropdownlist is showing and the the mouse is over a different part of the form, the drop down list stays open and moves away from combobox when the mouse wheel is used. Has anyone else experienced this and is there a resolution? See attached picture.

Generic MouseWheel Scroll for UserForm and for ALL its Controls !

Hi all, Below is a code for scrolling all controls in a userform with the Mouse Wheel Should work with Modal as well as with Modeless userforms .. Tested in 32Bit and 64Bit systems .. Also, the code doesn't use a Windows hook so it should be stable and safe. See Workbook Demo 1- Code in a...

www.mrexcel.com

 

[sijpie]

I haven't experienced the particular issue that you show, but too many other issues. So in the end I deleted the code. All the solutions use API hooks into the system. Mouse events come so often, and then there are so many that the hooks can't keep up, I think. VBA is a slow language. If you program you userform in C# or C++ you won't have an issue