Private Sub ComboBox2_Change()
If Application.CountIf(Sheet1.Range("B:B"), ComboBox2.Text) = 1 Then
a = Sheet1.Range("B:B").Find(ComboBox2.Text, LOOKAT:=xlWhole).Row
For B = 1 To 13
Me.Controls("textbox" & B) = Sheet1.Cells(a, B + 1)
Next B
ComboBox1.Text = Sheet1.Cells(a, 1)
Else
MsgBox ComboBox2 & " 不存在"
End If
End Sub