Populate TextBox from ListBox

andxie · #1 07-03-2018, 05:33 PM

Hi,

I would like to know how could I populate multiple textboxes when an item on the listbox has been clicked?

See attched image.

also how could I edit the data by just clicking on the item on the listbox?

Thank you

NoSparks · #2 07-03-2018, 06:57 PM

Short answer.... use the list boxes Click event.

Where is the data to be loaded into the text boxes in relation to what shows in the list box ?

A sample Excel file would be more beneficial than a picture.

andxie · #3 07-04-2018, 12:09 AM

Here is the sample file.

NoSparks · #4 07-04-2018, 06:27 AM

Code:

Private Sub ListBox1_Click()
Me.TextBox1.Value = Application.WorksheetFunction.VLookup(ListBox1.Value, Range("B2:E3"), 3, False)
End Sub

andxie · #5 07-08-2018, 04:56 PM

how do I show all the details about that product on all the textboxes?

NoSparks · #6 07-09-2018, 07:04 AM

The suggestion is one way to populate a textbox based on the listbox selection.
Do the same for each textbox.

Your example file is nothing like your picture.
Is it reasonable to presume it's a VBA user form ?

Debaser · #7 07-16-2018, 01:47 AM

If you load all the data into the listbox initially (you can hide any columns you don't want displayed), then you can simply access the List property of the listbox directly to assign any column to another control, rather than having to access the worksheet again.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populate listbox	eduzs	Word VBA	4	07-18-2017 05:28 PM
This is a Userform LIstbox queston: A variable does not set to the value of a listbox	CatMan	Excel Programming	14	08-18-2014 08:14 PM
This is a Userform LIstbox queston: A variable does not set to the value of a listbox	CatMan	Excel	1	08-08-2014 09:41 AM
how to populate textbox based on combobox selection in word	IvanGeorgiev	Word	1	02-21-2013 07:32 PM
how to populate textbox based on combobox selection in word	IvanGeorgiev	Word VBA	1	02-21-2013 07:28 PM