I have looked through an extensive thread in which @Jaafar Tribak and @Gokhan Aycan provided some VBA code to allow the mouse wheel to scroll in various objects within a userform. I even created a new workbook and a new userform with all the labels, listboxes, comboxes, and textboxes defined in the code found here POST #78 and posted the code directly into a standard module (the first section) and into a new userform (the second section). I can launch the userform and the various objects populate with the information in the "userform-initialize" code but as soon as I roll my mouse over the userform, I get an "Automation Error. Exception occurred" error and have to force-close excel to get past it.
Does anyone have a valid, working solution to allow for mouse wheel scrolling in userform comboboxes with Excel 365 or know how to modify the code linked earlier to work with Excel 365?
THANKS!
Does anyone have a valid, working solution to allow for mouse wheel scrolling in userform comboboxes with Excel 365 or know how to modify the code linked earlier to work with Excel 365?
THANKS!