Scroll ComboBox in Userform in Excel 365

bsweet0us

New Member
Joined
Apr 12, 2008
Messages
38
Office Version
  1. 365
Platform
  1. Windows
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!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,214,987
Messages
6,122,613
Members
449,090
Latest member
vivek chauhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top