Thank you for responding.

I don't have enough room because of other boxes within the userform. Is
there a way to make a useform full screen? Like maximize/Minimize? That might
help.


"JLGWhiz" wrote:

I am not sure what you mean by "don't have enough room to make the listbox
larger. If it is on a UserForm, you can expand the UserForm and then widen
the listbox. If it is not on a user form, you can reposition the control on
the sheet an widen the listbox using the width property. It seems to be the
only option if you have to use the listbox.

"Benz" wrote:

Hi,

I have a listbox which pulls from a column in my worksheet, each cell has a
line of text. My problem is Some of the text gets cut off.

1.) I do not have room to make the listbox larger
2.) I need the sorting capabilites that the listbox offers
3.) I dont believe there are the same text options (Multinline , wordwrap)
as with textbox's
4.) Ive tried creating it as a multi- column listbox but then it doesnt
pull the correct defined cells from the worksheet

Any help would be appreciated.

Thank You.