Posts by Wondmand

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!

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.