Populating multiple text boxes based on a combobox

  • I've found many answers to my question and attempted to adapt them to my specific needs to no avail. Hopefully someone can tell me what I'm doing wrong. I have a worksheet ("Data") with a SKU in A, Description in B and Ref in C. All data has defined name (SKU, Description, Ref are the names).
    In my userform, ComboBox1 is a drop down list based on the SKU. Once the user selects a number from that drop down list, I need TextBox1 to populate with the Description and TextBox2 to populate with the Ref.

    Any help would be GREATLY appreciated! I would show what my code currently is, but I keep starting over...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!