Hi all, anyone can teach me how to make the horizontal scroll bar in
list box?
actually, the vertical scroll bar is appeared automatically whehn the
contents are more than list box size. However, a created a list box to
show the path of the files. Since the path is so long and longer than
the list box, thus, I / users not able to read the full path..... can
you help?

I looked at the documentation for the ListBox object in VBA and didn't see
anything about a scroll bar, vertical or horizontal, among the properties.
Maybe that's not one of the things you can control, though it would surrise
me.

--- " wrote:
Hi all, anyone can teach me how to make the horizontal scroll bar in
list box?
actually, the vertical scroll bar is appeared automatically whehn the
contents are more than list box size. However, a created a list box to
show the path of the files. Since the path is so long and longer than
the list box, thus, I / users not able to read the full path.

If you are using an ActiveX ListBox, just set the ColumnsWidths property to
a number large enough to show your longest item.

--
Rick (MVP - Excel)


wrote in message
...
Hi all, anyone can teach me how to make the horizontal scroll bar in
list box?
actually, the vertical scroll bar is appeared automatically whehn the
contents are more than list box size. However, a created a list box to
show the path of the files. Since the path is so long and longer than
the list box, thus, I / users not able to read the full path..... can
you help?