CODEWITHSUNDEEP
excelexcel-2007mousewheeluserformvba
ReidC
ReidC

Reputation: 33

Enable mouse wheel scrolling in combobox/listbox

I am building a userform in Excel 2007 using VBA and would like to know how to enable mouse wheel scrolling of comboboxes and listboxes.

Do I need a more recent version of Office to get this feature or is it something that can be coded for?

Upvotes: 2

Views: 42193

Answers (1)

Our Man in Bananas
Our Man in Bananas

Reputation: 5981

if using 32-bit Windows then the solutions by PETER THORNTON using WIN32 API calls on the below page will help:

MSDN Forums - Visual Basic For Applications: Mouse scroll in UserForm ListBox in Excel 2010

The OP on that page was using Excel 2010 but as it's API calls doing the work, so long as you are using 32-bit Windows then that should work for you too.

Philip

Upvotes: 1

Related Questions