Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Horizontal Scrollbar on listbox
Thanks in advance...
I'm filling a listbox using the rowsource property. Although the names are not too long for the listbox (not even close) it is adding a horizontal scrollbar automatically. I checked and there are not leading or trailing spaces on any of the list items. What property can I change to remove the horizontal scrollbar. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Horizontal Scrollbar on listbox
The default "ColumnWidths" are quite wide. Set that property to the widths
you need, e.g. 50;50;50; etc. A semicolon is the separator. -- Jim "Stephen Lloyd" wrote in message ... | Thanks in advance... | | I'm filling a listbox using the rowsource property. Although the names are | not too long for the listbox (not even close) it is adding a horizontal | scrollbar automatically. | | I checked and there are not leading or trailing spaces on any of the list | items. | | What property can I change to remove the horizontal scrollbar. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Horizontal Scrollbar on listbox
Thank you, that did the trick
"Jim Rech" wrote: The default "ColumnWidths" are quite wide. Set that property to the widths you need, e.g. 50;50;50; etc. A semicolon is the separator. -- Jim "Stephen Lloyd" wrote in message ... | Thanks in advance... | | I'm filling a listbox using the rowsource property. Although the names are | not too long for the listbox (not even close) it is adding a horizontal | scrollbar automatically. | | I checked and there are not leading or trailing spaces on any of the list | items. | | What property can I change to remove the horizontal scrollbar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making listbox without horizontal scrollbar | Excel Programming | |||
Listbox horizontal scrollbar problem | Excel Programming | |||
Unwanted Listbox Horizontal Scrollbar | Excel Programming | |||
Needless Horizontal scrollbar in Listbox | Excel Programming | |||
Horizontal scrollbar in ListBox | Excel Programming |