Loop through listview RRS feed

  • Question

  • Hi Guys,

    I am a beginner in the excel vba, and i have a question abot the listview control.

    I have two tables. One table is assembly table - the table (listview) consists of parts of the selected assembly, with materials to be used for the parts of the assembly with required quantities. The other table (excel sheet) is material table (with quantities) from the stock. 

    I need a code for every part of the assembly table (listview) to loop through the material table(excel sheet) and for every part of the assembly table if the quantity of material in stock is less than required or equal to ''0'' to display those parts in third listview table?


    • Edited by JolleXlS Sunday, June 30, 2019 1:54 PM
    Sunday, June 30, 2019 1:53 PM