Items in Userform Listbox are wider than list box. Need to see all character of item

[welchs101]

Hi, I have enclosed a test file to help explain my problem.

I have a userform that i created. There are two listboxes on the userform.

I populate the listboxes with values and some of these values are "wider" than the listbox itself.

Is there something i can do so that the user can see the entire item show in the list box. The items shown in my test example (see enclosed) are wider than the listboxes on the userform...........do i need to add a scroll-right button or something .....

Any ideas on what to do?

[Winon]

Hello welchs101,

I cannot find a way to correct your problem with code, and neither does adding a ScrollBar help. The only way I could solve this one, was to widen the ListBoxes to an anticipated maximum width.

Hope that helps!

[Leith Ross]

hello welchs101,

Set the ColumnWidth property on each ListBox to 640 pt. This should provide you enough horizontal scroll room.

[welchs101]

thanks guys.

Leith, i decided to go with you suggestion......thanks.