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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.