Solved: Listbox selection change

[slamet Harto]

Hi there,

do me a favor, if I want to show a value based on listbox selection.

For instance:
If selection changed in listbox then we show a value in column E.

Kindly advice

Thank in advance and have a nice weekend.
Rgds,
Harto

[slamet Harto]

If selection changed in listbox then we show a value in column E.

I mean, Textbox2 is showing a value based on column E

Example:
listbox selection row 1 is
10.1MD0

then textbox to is A

[Bob Phillips]

I have never seen anyone call a listbox TextBox2 before!

[vba]

Private Sub ListBox1_Click()
With Me

If .ListBox1.ListIndex >= 0 Then _
.Textbox2.Clear
.Textbox2.AddItem .ListBox1.List(.ListBox1.ListIndex, 3)
End With
End Sub
[/vba]

[slamet Harto]

Hi Bob

Its work fine and will change textbox to another listbox.
Thank you for assistance.

Best rgds,
harto

[mikerickson]

[VBA]Private Sub ListBox1_Change()
With Me
.TextBox2.Text = .ListBox1.Text
End With
End Sub[/VBA]