AnsweredAssumed Answered

VBA ListBox Search

Question asked by caseyogden on Mar 7, 2012
Latest reply on Mar 8, 2012 by kenbuja
Hi,

I'm trying to Search for a string within a listbox but it will only find it if it is the first or last entry in the listbox.  What is the appropriate way to loop through.

For j = 0 To listbox2.listcount -1
value = listbox2.list(j)
next j

If InStr(1, value, "Well") Then  
MsgBox "YES"
End If

Thank  you.

Outcomes