Getting rid of scrollbars for listbox

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
 
T

Tom Ogilvy

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.
 
M

Marcie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get rid of scrollbars in listbox. 1
Horizontal Scrollbar on listbox 2
Needless Horizontal scrollbar in Listbox 2
Capture listbox selection to a cell in a different sheet 2
Listbox horizontal scrollbar problem 1
Wrapping entries in a ListBox 1
Scrollbars in Listbox 2
Excel 2007 listbox width problem 1

Top