listbox isempty

[Talk2Tom11]

I want to be able to check if a listbox is empty... and then if it is do someone accordingly.

But i can't find something like a .isempty. How would i check to see if the listbox is empty?

in VB.

 

[Mike_R]

Checking if the .Count = 0 should do the trick...

 

[vbMarkO]

Yep like He said the .count. However to check it then doing something would require a statement .... you can do this several ways but as to your question you said if it is then do something so we will use an If statement

   If listbox1.items.count = 0 Then
    ' Do something
   End If

That should get it done!

vbMarkO