show row source data in listboxes

[jpruffle]

Hi,

I have used a userform found on this forum (I cannot find the link) that displays row data from a range within a listbox. Unfortunately though you cannot determine the column width. As such I wondered if it was possible to show the data within other listboxes. So for example in listbox1 you can see 5 columns accross (from a range) however one of them is very wide.

Looking at Listbox1 you can only see the firsy 20 characters approximately in each column. Is it possible therefore that once this row of data is selected that the contents of the columns is duplicated in other listboxes on the same userform that can be expanded to accommodate larger text?

I have enclosed a userform with what I have done thus far. Any help would be greatly appreciated. Thank you in advance.

[royUK]

Why not just change the column width of the listbox?

[jpruffle]

Thank you for the quick reply. Firstly because I do not know how to define the width of the columns that are displayed within the listbox. But secondly it would make it easier for the end user to see. In my form that I have created the two columns are for notes and can run to 100 words plus. Ideal for another listbox but not for being displayed as a long column.

I don't know if I make any sense but I hope that explains why.

[jpruffle]

Hi,

I have amended the form to make it a little easier to explain what I am looking for. Please can someone take a look and try to advise?

Thank you in advance.

[royUK]

This example has code to do that. Look at the ListBox1_Click event

FilterForm.zip

Please Login or Register  to view this content.

[jpruffle]

Thank you very much Roy. I managed to work it into my form perfectly.