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??
Bookmarks