UserForm ListBox

[Otto Moehrbach]

Excel 2002
Be gentle with me. This is the first time I have tried to build a UserForm
in at least 10 years. Having a ball!
I have two list boxes in my UserForm. One of them is a list of names
and does just right.
The second listbox is a list of just:
a
b
c
d
That's all.
However, this listbox insists on displaying left/right scroll arrows across
the bottom of the listbox. What have I done wrong?
Thanks for your help. Otto

 

[Tom Ogilvy]

look at the columnwidths property. If the columnwidths (total column widths
for all columns) are less than the width of the listbox, you shouldn't get a
horizontal scroll bar

 

[Harald Staff]

Hi Otto

Do you have a hardcoded column width in that box ? Or is it "a " instead of "a" ?
It's the only options I can think of.

 

[Otto Moehrbach]

Tom
Thanks for your help. The ColumnWidths property was blank. I put in a
1 and the horizontal scroll bar went away. That goes in my notes. Otto