I'm still not having any luck.


I'm grabbing text from four texboxes and adding it to a list view with four columns with the click of a button. What is the Syntax for checking if the data I'm about to add to the listview already exists? Here's my current code that adds data to my columns.

Private Sub cmdAddToListView_Click()

Set sitem = lstCustomers.ListItems.Add(, , txtFields(1).Text)

sItem.SubItems(1) = txtFields(2).Text
sItem.SubItems(2) = txtFields(3).Text
sItem.SubItems(3) = txtFields(4).Text

End Sub