Thread: ListBox1 = ""
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wobbly[_2_] Wobbly[_2_] is offline
external usenet poster
 
Posts: 3
Default ListBox1 = ""

Why doesn't this work:

Private Sub CommandButton1_Click()
If ListBox1 = "" Then
MsgBox ("True")
Else
MsgBox ("False")
End If
End Sub

While this does:

Private Sub CommandButton1_Click()
If ListBox1 < "" Then
MsgBox ("True")
Else
MsgBox ("False")
End If
End Sub

or have I missed something embarrassingly obvious?
Cheers Wobbly.