'Connect' two listboxes

[D_N_L]

Hi all,

I have Listbox1 which shows the values in columns D to I. The info in column J I want to show in another Listbox (the reason being is a design one as the length of string is quite long).

I am trying to ‘connect’ the two list-boxes together so that when Listbox1 is scolled up/down then Listbox2 follows suit. I have tried using the Initialize event to call a Vlookup but I can’t seem to get it to work. Any ideas?

Please Login or Register  to view this content.

This is my working Listbox1 code:

Please Login or Register  to view this content.

[Izandol]

In Initialize event Listbox2 will have Listindex -1 unless you change it. You may add code to Listbox1 click event to populate listbox2 - it will be simple if you will populate listbox1 with all data and then you may simply assign chosen column to listbox2. However I think multi-line Textbox may be simpler.

[D_N_L]

Thank you Izandol. That makes sense. I'll try and work it out. : )

[D_N_L]

Hi Izandol,

I tried putting this at the bottom of the Listbox1 sub but no good. In fact I can't work out how to assign anything to a LB. I'm not a heavy user of forms.

Private bSkipEvents As Boolean

Please Login or Register  to view this content.

[Izandol]

Which column will be added to Listbox2? Also, if you are adding to listbox control, I assume there should be more than one item? Therefore probably you will need Split:

Please Login or Register  to view this content.

[D_N_L]

Hi,

Column J.

At the moment ListBox1 shows everything I need (D2:J50). Essentially I want ListBox2 to show the 'J' and LB1 to show D:I.

[Izandol]

Did you test the code I have posted in last post?

[D_N_L]

It works! Woo! Sorry forgot to test.

I don't want to push your generosity but can I make the text wrap within the listbox (i.e. - over more than one line)?

[Izandol]

It will split on line feed character (Alt + Enter in cell). If you do not have this, you must decide how to split?

[D_N_L]

I see. I'd probably want to split it every nth character. Possibly every hundredth. : )

[Izandol]

May you not use multi-line textbox or simple textbox with wrap text option?

[D_N_L]

Ahh yes, of course. Thank you VERY much Izandol. Very kind.