Good afternoon,
I am creating an excel program that tracks vacation time. My issue is if you were to cancel vacation time and I want to delete that row.

I have a combo box with an active range of names that updates as new names show up.

i have another box (I have tried a listbox and combo box) that will display the start date of all vacation times that person has put in for.

I am using this code:

Dim iLastRow As Long
Dim i As Long

iLastRow = Cells(Rows.Count, "a").End(xlUp).Row
For i = iLastRow To 1 Step -1
If Cells(i, "a").Value = LEAVEDELETE.SAILORpick.Value And Cells(i, "b").Value = LEAVEDELETE.LEAVE.Value Then
Rows(i).DELETE
End If
Next i

where leavedelete is my userform, sailorpick is the first combo box with names, and leave is the 2nd box with a list of start dates.

I have tried this code and it worked:
If Cells(i, "a").Value = LEAVEDELETE.SAILORpick.Value And Cells(i, "b").Value = "(manually puting in date here)" Then

for some reason, the value in the listbox/combobox is not the same value as the cell with the actual date even though they read the same and in the same format.

Any suggestions??