Scrolling ActiveX combobox

[BimmerRacer]

I have an active x combobox and when I expand it and scroll down, instead of scrolling in the list, it scrolls the actual excel window, leaving the dropped down portion of the combo box "detached". How do I remedy that?

 

[RoryA]

Don't use the scroll wheel on your mouse.

 

[BimmerRacer]

Seriously? That's the "functionality"?

 

[RoryA]

Yep. ActiveX controls and worksheets don't really play well together.

 

[BimmerRacer]

Cool, thanks

 

[RoryA]

Do you actually need an activex control rather than a DV dropdown (or even a forms combobox, which doesn't scroll, but at least doesn't scroll the sheet either!)

 

[BimmerRacer]

I do. I don't think forms dropdown has all the properties I need.

 

[RoryA]

Then I think you're out of luck. (the scrolling doesn't work on the list part in a form either).

 

[BimmerRacer]

That's OK. I'll let the users know. Thanks