Multi-Column Listboxes correspond to multi textboxes

**Crebsington** · 02-02-2012, 10:20 PM

I am Stumped...

I have set up a userform that contains a listbox with 6 columns. Above that I have 6 textboxs that I would like to correspond to the Listbox.

So when I select a row on the listbox, the cells of that row populate the textboxes.

Is this possible??

Thank you for your Time!!

-Kyle

**pike** · 02-03-2012, 09:23 PM

Hi Crebsington
what have you tired?

**jaslake** · 02-12-2012, 01:38 PM

Hi Kyle
Try this code

Option Explicit
Private Sub ListBox1_Click()
    With ListBox1
        TextBox1.Text = .List(.ListIndex, 0)
        TextBox2.Text = .List(.ListIndex, 1)
        TextBox3.Text = .List(.ListIndex, 2)
        TextBox4.Text = .List(.ListIndex, 3)
        TextBox5.Text = .List(.ListIndex, 4)
        TextBox6.Text = .List(.ListIndex, 5)
    End With
End Sub