Private Sub ComboBox1_Change()

    Dim 직원 As Range
    Dim 찾은셀 As Range
    
    If ComboBox1.MatchFound = True Then
    
        Set 직원 = Range("C3", Cells(Rows.Count, "C").End(xlUp))
        Set 찾은셀 = 직원.Find(What:=ComboBox1.Value, LookAt:=xlWhole)
    
        With TextBox1
            .Value = 찾은셀.Offset(, 2).Value
            .TextAlign = fmTextAlignCenter
        End With
        
        With TextBox2
            .Value = 찾은셀.Offset(, 3).Value
            .TextAlign = fmTextAlignCenter
        End With
                    
    Else
                    
        TextBox1.Value = ""
        TextBox2.Value = ""
        
    End If
    
End Sub
