I have current Code:
Private Sub ListBox1_Change()
TextBox1.Value = ListBox1.List(ListBox1.ListIndex)
End Sub
Private Sub UserForm_Initialize()
ListBox1.RowSource = "a10:c20"
End Sub
I can't get my Textbox to show all 3 columns in the listbox selection, any ideas?
also I am ultimately trying to enter a list from a range (into listbox1) and edit the choosen line in the text box.Then when ok is hit edit the worksheet in the right spot. Am I on the right track?
Thank You
Private Sub ListBox1_Change()
TextBox1.Value = ListBox1.List(ListBox1.ListIndex)
End Sub
Private Sub UserForm_Initialize()
ListBox1.RowSource = "a10:c20"
End Sub
I can't get my Textbox to show all 3 columns in the listbox selection, any ideas?
also I am ultimately trying to enter a list from a range (into listbox1) and edit the choosen line in the text box.Then when ok is hit edit the worksheet in the right spot. Am I on the right track?
Thank You