Select Combobox and populate Listbox

Hello guys,

I am working on a inventory table and I am just a newbie on vba.

So what I am looking for is:

I want to select the description of the product on a combobox and I want it to populate a listbox showing automatically for example: part code / category of it .
What is important for me is that the listbox returns the exact match reading the actual database. I don't want to change the structure.

It is true that there is a lot of information about this on this great site and others but unfortunately I tried several code but did not managed to get it working.

you can see the file enclosed.

Thanks in advance.

Hi

I have added the code for you.

You need to add code to show and hide the lis tbox as you wish.

Hello mehmetcik,

Thanks for your help.

Well it is displaying all the info relative to the description, but it shows all together on Listbox.

I would prefer a way I could put it on separate textboxes. Because at the end the porpose when clicking OK button will copy it for each place on excel sheet.

The fact is that I'm really nooob and I was not able to change your code to do it as above.

In case you could give a hand I would appreciate it.

Thanks

Hi

Clicking Ok will now read the information from the Listbox and write it to your spreadsheet.

There is no need to mess about with Text Boxes.

As you are not going to change any of the data, this is a neater solution.

Hi Mehmetcik,

Thanks for helping.

But the file was already copying information to the spreadsheet, no need to do that.

The only thing I really need is to show the exact info on listbox or texbox, ex: part code or category according to the product selected on combobox.

Please do not think on the example I am sending, this is only an example to explain what I need.

I really thank you for the help you are giving and hope you can come up with a solution.

Thanks.