View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eddie_SP[_2_] Eddie_SP[_2_] is offline
external usenet poster
 
Posts: 47
Default If ListBox = "" then

Hi Community !

I have a huge loop which opens some files from the server of the company I
work.
I have a search button, for pieces about to arrive our warehouse.
I need to know if there's something I can do after all the loop, if any
piece was found, the message "NO RESULTS FOR THE ITEM YOU ARE SEARCHING."
apperas in line 1 of the listbox.

I do not want to change the loop routine, I just need a command after the
loop.

Thank you !