Adjust listbox to display string longer than listbox width using Excel VBA

Question

In my listbox the strings are longer than the listbox width.

I cannot change the listbox width because of the already made up surface design:

Is there a VBA property for the listbox to:

break the string in half and display it on more than one line

or

scroll horizontally, to see the whole string

If there's not that kind of property, I'd like to know of other ideas.

What happens if you insert a return character CHR(13) or CHR(10)? Perhaps insert that if a length exceeds a certain amount? — pgSystemTester
– pgSystemTester, Commented Mar 18, 2019 at 15:30
@PGCodeRider Good idea, ill try that...let you know if it works — J.schmidt
– J.schmidt, Commented Mar 18, 2019 at 15:33

Pᴇʜ · Accepted Answer · 2019-03-18 15:41:11Z

2

The ListBox is single line only and does not support line breaks.

If it is an ActiveX then it has a property called ColumnWidths. Set it to something bigger like 500 and you will see a scrollbar at the bottom of the ListBox.

answered Mar 18, 2019 at 15:41

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adjust listbox to display string longer than listbox width using Excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related