Posts by Wondmand


    [Blocked Image:]
    Thanks in advance,
    What I am trying to do is use a userform combobox to make a selection and populate multiple textboxes within that userform. The sheet that the values from the combobox are found in Column A. The values occur more than once. The values that are needed to populate the text boxes are found in adjacent cells. For example dog is chosen in the combobox:
    Column A Column B Column C
    Row 1. Dog Lab Collie
    Row 2. Cat yellow Black
    Row 3. Dog Shepherd Rot
    textbox1 populates with Lab
    Textbox2 populates with collie
    Textbox 3 populates with Shephard
    Textbox4 populates with Rot
    Any help would be great!

    Thanks in advance...I have a combobox with a list that is populated on userform load. I am using an multipage with 2 tabs. My combobox is titled ACFTBOX I have the following textboxes:
    MSL1, 2, 3, etc through 12
    D1 ,2, 3 etc through 12
    S1, 2, 3, etc through 12
    L1, 2, 3, etc through 12
    F1, 2, 3, etc through 12
    P1, 2, 3, etc through 12
    C1, 2, 3, etc through 12

    The data is stored on Sheet "Serial Number" across 8 columns
    Column 1--MSL
    Column 2--ACFT
    Column 3--D
    Column 4--S
    Column 5--L
    Column 6--F
    Column 7--P
    Column 8--C

    The Combo box is populated from Column ACFT
    This column will have multiple occurrences of the same number i.e. A0035

    What I am trying to do is use the combo box to locate the ACFTBOX.value and populate the appropriate text boxes for each time the ACFTBOX is found.

    I know this is confusing so I have attached a sample document. The tab titled aircraft history is the one I am looking to populate. The tab title New PRD is working

    Any help would be great. I know the existing code could be made more simple but it's what I am familiar with.