Populate Userform Textbox from Combobox Selection

  • Voted
    Clear
    Vote




    [Blocked Image: https://www.teachexcel.com/images/loading_medium.gif]
    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!

Participate now!

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