PDA

View Full Version : Solved: Listbox selection change



slamet Harto
12-05-2008, 03:35 AM
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
12-05-2008, 03:40 AM
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
12-05-2008, 06:21 AM
I have never seen anyone call a listbox TextBox2 before!



Private Sub ListBox1_Click()
With Me

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

slamet Harto
12-05-2008, 01:53 PM
Hi Bob

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

Best rgds,
harto

mikerickson
12-05-2008, 11:37 PM
Private Sub ListBox1_Change()
With Me
.TextBox2.Text = .ListBox1.Text
End With
End Sub