View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default UserForm ListBox

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