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. :cool:

[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