Getting rid of scrollbars for listbox

  • Thread starter Thread starter Marcie
  • Start date Start date
M

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
 
Sure you didn't change the StandardWidth property of the worksheet itself.
I have never heard of what you describe and it makes no sense.
 
When I put a listbox in my worksheet it automatically has a horizontal
scrollbar after I put entries in it. And no matter how I size it using
the sizing arrows, the scrollbar stays. I hope that made more sense.
And when I change the width of the listbox by right clicking on it and
clicking "Properties" it changes the width of everything on the
worksheet.

Marcie
 
Back
Top