View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default If ListBox = "" then

Hello Eddie,

Not sure I really understand. You say "if any piece was found, the message
"NO RESULTS FOR THE ITEM YOU ARE SEARCHING." apperas in line 1 of the listbox.

Am I correct in assuming that you are getting this message when something is
found? If so, can you share the code you have otherwise it is difficult to
know what needs to be altered to correct it.

If my assumption is not correct then perhaps some more explanation as well
as sharing the code.

--
Regards,

OssieMac


"Eddie_SP" wrote:

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 !