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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,215,491
Messages
6,125,101
Members
449,205
Latest member
ralemanygarcia

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