View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
MikeM MikeM is offline
external usenet poster
 
Posts: 64
Default Removing Scroll Bars from a Listbox on a Form

Thanks, Peter. I didn't notice the entry "ColumnWidths" in the Properties
window. It was blank, so I set it to a small number and got rid of the scroll
bars!

"Peter T" wrote:

Try making the ColumnWidths a tad less than the overall with, implicitly if
necessary. For the vertical scroll bar I think that would only appear if the
height does not accommodate all the rows.

Regards,
Peter T


"MikeM" wrote in message
...
"MikeM" wrote:

I have a simple listbox (M, F), but when I try to reduce its size to just
fit
the text both horizontal and vertical scroll bars fill up the box. How do
I
eliminate them?


I should have added: can it be done in the Listbox properties window, or
does it have to be done in code?



.