Getting rid of scrollbars for listbox
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Getting rid of scrollbars for listbox
 

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.

--
Regards,
Tom Ogilvy

Marcie wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Getting rid of scrollbars for listbox
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/