Userform Listbox Help

[magicman1998]

Hi Everyone,

Ive made an inventory tracking sheet that uses userforms to control the data, but its also used to display the data.
One of the listboxes within this is pulling data from one of the database sheets in the workbook.

The image shows the code that works currently with just the data from the worksheet.
I want it to also pull one row of data from a row of another sheet in the workbook and put it on the end. Obviously both sheets have a common variable with the data so the data must match up with the correct product name from both lists.

I have no idea how to do this, every idea I have and try doesnt seem to work and I get debug pop ups and compile errors.

Please help

Thanks in advance
Liam

 

[magicman1998]

The data from the second worksheet is in a sheet called "Products" and the first row is the product name and the 3rd row is the row I wish to plonk on the end of the other data in the listbox

 

[RoryA]

Welcome to the forum.

A picture of code is of little use to us - we'd have to retype it to debug/alter it. Please post the actual code, using code tags. Thanks.