i have created an excel file.i need to check if the value of one the cell value and if true display other cell values in a listbox.all i m getting is a blank listbox.
For i = 2 To i = 100


If (xlsheet.Range("2,i").Value = ("GAME")) Then
a = (xlsheet.Range("1,i").Value)
List1.AddItem (a)


End If
Next i
help needed