Set ITM = Listview1.FindItem(

[sal21]

Googling...
I need to use the function in object to find MyVar in column 3 of listview1 and return boolean value..
How to?
Tks.

[HansV]

Should the text in the column be equal to MyVar, or should it contain MyVar (with possibly other text)?

[sal21]

Should the text in the column be equal to MyVar, or should it contain MyVar (with possibly other text)?

... i need to find only in column 3 if it contain a MyVar value in any row of column

[HansV]

The following will tell you if MyVar is found in any subitem:

Code: Select all

    Dim MyVar As String
    Dim IsFound As Boolean
    MyVar = "..."
    IsFound = Not (Me.ListView1.FindItem(MyVar, lvwSubItem, , False) Is Nothing)
    MsgBox IsFound

[HansV]

And this will tell you if MyVar is found in the 3rd column:

Code: Select all

    Dim MyVar As String
    Dim IsFound As Boolean
    Dim itm As ListItem
    MyVar = "..."
    Set itm = Me.ListView1.FindItem(MyVar, lvwSubItem, , False)
    If Not itm Is Nothing Then
        IsFound = itm.ListSubItems(2).Text = MyVar
    End If
    MsgBox IsFound

[sal21]

And this will tell you if MyVar is found in the 3rd column:

Code: Select all

    Dim MyVar As String
    Dim IsFound As Boolean
    Dim itm As ListItem
    MyVar = "..."
    Set itm = Me.ListView1.FindItem(MyVar, lvwSubItem, , False)
    If Not itm Is Nothing Then
        IsFound = itm.ListSubItems(2).Text = MyVar
    End If
    MsgBox IsFound

GREAT!.
TKS