How do I disable the scroll bar in a listbox?

[peter_z]

Hey Guys,

I have a list box and I want to keep it the same size but for some reason one of the columns in the list box have a scroll bar which I want to get rid of even though the txt fits perfectly.

Does anyone have any code that disables the scroll bar?

Cheers for your help

 

[Norie]

Peter

Which of these listboxes do you have on the worksheet?

The left one is from Forms and the right an ActiveX control.