Private Sub CommandButton1_Click() '查找用户在A列的
With Sheets("客户资料")
s = WorksheetFunction.Match(TextBox1.Text * 1, .[a:a], 0)
.Cells(s, 5) = TextBox4.Text
End With
End Sub
Private Sub CommandButton1_Click() '查找用户在A列的
With Sheets("客户资料")
s = WorksheetFunction.Match(TextBox1.Text * 1, .[a:a], 0)
.Cells(s, 5) = TextBox4.Text
End With
End Sub