Tuesday, April 4, 2017

Scroll in Excel-VBA listboxes

Included by default in all applications created starting early 2016


Pure VBA in Excel

VBA in Microsoft Excel lacks a lot of new features, but that did not stop us from loving it

One of those features is scrolling with mouse whee, since VBA is technically VB6 that was created prior to scroll wheel.

Yes, VBA in Excel is that old

So an alternative way is to use "Scroy"

Drag with your right-mouse to scroll through items in a listbox

Download XLSB example