View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default UserForm ListBox

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
"Tom Ogilvy" wrote in message
...
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

--
Regards,
Tom Ogilvy

"Otto Moehrbach" wrote in message
...
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