Excel VBA Userform Vlookup - Populate TextBoxes dependent on ComboBoxes

[Gene31705]

Good morning MrExcel Members.

I'm requesting help on VBA code to populate TextBoxes based on what is entered into ComboBoxes.
I have a combo box

• (TailNumber_cbo)

I have three Text Boxes

• AircraftType_txt,
• EquipmentType_txt
• Color_txt)

All three inside a Frame (Aircraft_fra)

• My TailNumber_cbo is populated from my RowSource (=TailNumber) located on Sheet5 (Equip Codes).
• My AircraftType_txt should be a Vlookup based on TailNumber_cbo selection and populated from Sheet5 (Equip Codes) number 2 (Column B).
• My EquipmentType_txt should be a Vlookup based on TailNumber_cbo selection and populated from Sheet5 (Equip Codes) number 5 (Column E).
• My Color_txt should be a Vlookup based on TailNumber_cbo selection and populated from Sheet5 (Equip Codes) number 6 (Column F).

I don't think this is required, but...
...I have the AircraftType as a Dynamic Named Range AircraftType.
...I have the EquipmentType as a Dynamic Named Range EquipType.
...I have the Color as a Dynamic Named Range Color.
All on Sheet5 (Equip Codes)

I have many other comboboxes and textboxes in my application but I assume if I understand how to do one, I can do all.

All of the entries on this userform will populate two separate Sheets; (Sheet1 (Log Book) and Sheet3 (Flight Plan));

• TailNumber_cbo will populate Sheet1 (Log Book) the next blank cell in column B
• TailNumber_cbo will populate Sheet3 (Flight Plan) cell C2
• AircraftType_txt and EquipmentType_txt will populate Sheet1 (Log Book) the next blank cell in column C (with a space between AircraftType_txt and EquipmentType_txt)
• AircraftType_txt will populate Sheet3 (Flight Plan) cell E2
• EquipmentType_txt will populate Sheet3 (Flight Plan) cell E2 (with a space between AircraftType_txt and EquipmentType_txt)
• Color_txt will populate Sheet3 (Flight Plan) cell A20

Thank you very much for your help.