Test this code please:
Private Sub ComboBox1_Change()
On Error Resume Next
'Look up values based on the first control
With Me
TextBox9 = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, Worksheets("Validation")..Range("B2:C88"), 2, 0)
TextBox10 = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, Worksheets("Validation").Range("B2:D88), 3, 0)
TextBox11 = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value,Worksheets("Validation").Range("B2:E88"), 4, 0)
I have made a working userform herewith illustrating this code and do not forget to mark the threas as solved if the code worked for you