PDA

View Full Version : ListBox not displaying Horizontal Scroll bar



Dr.K
12-12-2007, 09:59 AM
I have a ListBox in a UserForm that displays a multi-column list.
If the list contains enough rows to overflow the box, the vertical scroll bar shows up and behaves properly.

However, if the list gets too wide, the horizontal scroll bar does not show up!!! I need this becuase the last column "Investment Long Name", can be incredibly long, and I want the user to scroll over if they need to see it.

I can't find any scroll bar properties in the ListBox... Am I looking in the wrong place?

http://img225.imageshack.us/img225/3637/listboxwz5.jpg


Any help is appreciated.

Bob Phillips
12-12-2007, 10:26 AM
It is because you have multiple colums, it won't scroll past the last column default width.

What you need to do is to set the column widths, with a higher than neede value in the last, such as

50; 50; 200

Experiment with the values.

Dr.K
12-12-2007, 10:34 AM
hmmm... I thought of that yesterday, but I was unable to get it to work.
Clearly, I didn't fool around with it long enough.

Will having invisible columns at the end effect this?

Bob Phillips
12-12-2007, 11:00 AM
No, it's only the visible ones.