I have a listbox that gets populated with several items. When the list is
longer than the listbox, scrollbars (both vert & horiz) appear, even though
there is nothing to scroll horizontally. In userforms you can use
object.scrollbars = 2 to limit this to vertical scrollbar only. Is there a
way of doing this with listboxes? I don't see a scrollbars property for my
listbox.

Thanks for the help.

Mike

change the width of the listbox so it is slightly wider than the width of
the column (or all columns if multiple columns).

--
Regards,
Tom Ogilvy

"Mike Milligan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a listbox that gets populated with several items. When the list is
>longer than the listbox, scrollbars (both vert & horiz) appear, even though
>there is nothing to scroll horizontally. In userforms you can use
>object.scrollbars = 2 to limit this to vertical scrollbar only. Is there a
>way of doing this with listboxes? I don't see a scrollbars property for my
>listbox.
>
> Thanks for the help.
>
> Mike
>
>
>