I have a listbox which is populated with data from a worksheet (column count
= 5)

As the 6th column is a descriptive text field, I would like to hold the data
of the 6th column in another listbox on the same userform.

When the user clicks on the rows in the first listbox, I would like the 6th
column text field to show in the 2nd listbox.

Can anyone help me understand how I can make this happen.

Thanks.