The first two colums A & B are "Employee Name and Group". The form I'm working on manages my employee roster. I want the ability to "remove" an employee from my list. When I run this code, it works, however it clears the whole row. How can I re-write this so only data from column A & B are cleared based on the selection.
Code: Select all
Private Sub CommandButton2_Click()
Set ws = Worksheets("Data")
'Find Employee info
iRow = ws.Columns("A:A").Find(Me.List_employee.Text).Select
'Clear Employee name and Group
Selection.EntireRow.Value = ""