ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing Scroll Bars from a Listbox on a Form (https://www.excelbanter.com/excel-programming/439524-removing-scroll-bars-listbox-form.html)

MikeM

Removing Scroll Bars from a Listbox on a Form
 
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?

MikeM

Removing Scroll Bars from a Listbox on a Form
 
"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?

Peter T

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?




MikeM

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?



.



All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com