UserForm ListBox without horizontal scroll bars

[pbt]

How do you get rid or the horizontal scroll bar on a UserForm ListBox?

My ListBox is populated with just 2 letter abbreviations. It shows the scroll bar at the bottom which is not required with such a small width list.

I have tried adjusting some of the fields in the ListBox Properties with no luck. Searched the subject with no luck either.

Is there a way for the scroll bars not to show in this case?

 

[Norie]

Have you tried changing the ColumnWidths property?

 

[pbt]

Currently that Property is Blank.

Should there be something there, and if so what should that be.

I did play around with the Width Property (is that not the property to set the width of the ListBox?)

 

[Rick Rothstein]

Currently that Property is Blank.

Should there be something there, and if so what should that be.

The scrollbars means the width of the ListBox is narrow than the default size of a column (the control has no way of knowing your text does not, or will not ever, fill out to fill the default column width. I do not know off the top of my head what that default is, but I made ListBox 31.5 (scrollbars appeared) and then set the ColumnWidths property to 10 and the scroll bars disappeared. So, my suggestion is to experiment with different values in that property.

 

[pbt]

So, my suggestion is to experiment with different values in that property.

Your suggestion and Norie's point solves the problem.

I too was experimenting and determined that the ColumnWidth Property has to be at least 3 pts smaller then the Width Property.

The one thing that is still foggy for me is; where is it told to the programmer that this ColumnWidth property needs to be set for this type of situation? Is it available in a Help file/subject?