ListBox to TextBox on worksheet

Greetings everyone,

I've recently started programming with VBA outside of UserForms and directly on the worksheets. I'm struggling however with populating a TextBox based on ListBox.Click.

Let's say for instance my ListBox is filled with all the information from Worksheet 1, column A and I want the TextBox to show me whatever information I have on column B of the same row as the selected ListBox item.

On UserForm I'm used to achieve this by using ListBox_Click and Textbox1.value equals ListBox1.item + offset

How could this be done in the worksheet?

Thanks everyone!

Repost from Mr Excel Forum under #post 5259203

Hey! Thanks for your reply!

This is what I've been trying, however it fails to identify the range. Any thoughts?


Private Sub ListBox1_Click()
With ListBox1
TextBox_Detail.ScrollBars = fmScrollBarsVertical
TextBox_Detail.MultiLine = True
TextBox_Detail.WordWrap = True
TextBox_Name.Value = Range(.List(.ListIndex, 1)).Offset(, 1).Value
TextBox_Detail.Value = Range(.List(.ListIndex, 1)).Offset(, 2).Value
End With
End Sub