How do I get rid of scrollbars in listbox.

[Marcie]

Does anyone know how to get rid of the horizontal scrollbar that is
automatically given with a listbox? I tried make the width under
Properties larger, but all it does is shrink the whole sheet. Thanks in
advance.

Marcie

 

[Dave Peterson]

Listbox from the controltoolbox toolbar (on a worksheet)?

Show the controltoolbox
click on the design mode icon (looks like a drafter's square)
click on properties.

There's two properties that you want to play with:

..columnwidths and .width

Make that .columnwidth a little smaller than the .width. (difference of 3
worked ok on my pc--but I bet it depends on how wide your scrollbars are.)

======
(Same kind of thing if it's on a userform.)