Listbox Index Values

[Pacman52]

Hi could anyone let me know if there is a way to check if a row in a listbox index contains a number greater than 0 - something along the lines of this very rough example.

If ListBox1.ListIndex.value =< 0 Then.......do something

many thanks Paul

 

[Jeffrey Mahoney]

Private Sub Go_Btn_Click()
  Dim X As Long
  Dim Cnt As Long
  
  Cnt = ListBox1.ListCount
  
  For X = 1 To Cnt
    If ListBox1.List(X - 1) > 0 Then
      Debug.Print ListBox1.List(X - 1)
    End If
  Next X

End Sub

 

[Pacman52]

Many thanks Jeffrey