Currently, I have a combo box that is populated from a specific column in a spread sheet. On the userform, there is an Update page where I want the user to be able to choose something already in the combobox, and then press "delete from list." Is there a way for me to this?
Below is the code i'm currently using, but i'm getting "Run-Time Error '5': Invalid procedure call or argument" (I'm very new to vba)
Private Sub delLocateBTN_Click()
With Worksheets("READ ONLY")
If .Cells("F").Value = DelLocationcb.Value Then
.Cells("F").Select ' select the row
Selection.EntireRow.Delete ' now delete the entire row
ThisWorkbook.Save
End If
End With
End Sub
Bookmarks