excel vba

[nevilled]

When strolling in listbox I want the record of the of the listbox on which the cursor is to be displayed in the text box
the records in the textbox should keep on changing as I move the corsor up and down in the listbox
thanks in advance

 

[My Aswer Is This]

Try this:

Private Sub ListBox1_Click()
TextBox1.Value = ListBox1.Value
End Sub