Dependant Combox to autofill Textbox

  • I am making a form to help help amplify our quoting times. I have successfully made dependent comboboxs but I want to take it a step further

    combo box 1 - selects category

    combobox 2 - uses advanced filter to sort parts by selected category (displays part number and description which are 2 separate column's)

    would like to fill all the other textbox based on the part selected as they are unique to that part number.


    I then take this data and will load it into the corresponding worksheet which this option already works also.


    my issue is I can not get the textbox to fill based on other columns in that are associated to the part number selected. I have been trying several things the last couple days with zero luck


    any help is appreciated here is my current code and attached is the project


    Files

    • Temp.xlsm

      (33.94 kB, downloaded 76 times, last: )