View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Removing Scroll Bars from a Listbox on a Form

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?