ToolTip for listbox selected item

[ImranBhatti]

Hi,

In a multicolumn listbox in userform, I have a long string in third column,unable to adust/show full text. Is there a way to display full text of selcted item's column 3 value like tootiptext.

Or any smart way to display that long text to user

[romperstomper]

How long is the text at most? A couple of hundred characters? A thousand? More?

[ImranBhatti]

Thanks rorya for review

I calculated the length of the text for the some random files in specific column. The MAX of those lengths is 428 characters.

[ImranBhatti]

And yes the upcoming files may contain more so the average length of the text is pretty sure = 500 characters

[romperstomper]

I don't think, from memory, that you can put more than 255 characters into the tool tip, so I'd suggest using an additional control (e.g. a label) on the form that shows the data from that column as you select an item - assuming the listbox is not multiselect?

[ImranBhatti]

I'd suggest using an additional control (e.g. a label) on the form that shows the data from that column as you select an item - assuming the listbox is not multiselect?

Why it did not come to my mind?
Good idea