Scroll wheel in VBA

[xwb]

I was wondering whether to upgrade from Office 2003 to Office 2010. In Office 2010 VBA editor, does the scroll wheel work or is it the same as the old versions?

 

[strongm]

http://support.microsoft.com/kb/837910

 

[strongm]

(mind you having posted that, should just say that mouse scroll wheel works fine in IDE in my copy of Office 2010)

 

[xwb]

The mouse scroll wheel also works in the 2003 IDE but it doesn't in the generated forms. For instance, if I create a userform with a list box named lbGreek and add

Private Sub UserForm_Initialize()
    lbGreek.AddItem "alpha"
    lbGreek.AddItem "beta"
    lbGreek.AddItem "gamma"
    lbGreek.AddItem "delta"
    lbGreek.AddItem "epsilon"
    lbGreek.AddItem "zeta"
    lbGreek.AddItem "eta"
    lbGreek.AddItem "theta"
    lbGreek.AddItem "iota"
    lbGreek.AddItem "kappa"
    lbGreek.AddItem "lambda"
    lbGreek.AddItem "mu"
    lbGreek.AddItem "nu"
    lbGreek.AddItem "xi"
    lbGreek.AddItem "omicron"
    lbGreek.AddItem "pi"
    lbGreek.AddItem "rho"
    lbGreek.AddItem "sigma"
End Sub

When I run the code, the scroll wheel doesn't work unless I add some extra bits to the VBA. Is it still the same on 2010?

 

[strongm]

Ah, no. I'm afraid the Office 2010 userforms suffer the same shortcomings as earlier versions when it comes to mouse wheel support.

 

[xwb]

That's a bit of a bugger. Thanks for the information on userforms.