Message box help with loop

Hello,

I have some code that compares part of a filename to a list in a column then moves the file to a new folder if they match. However I can't seem to get the message boxes right. I want ONE message box to display "Files archived!" when the loop is finished and ALL the files that match have been moved, but also a msg box to display "File not found" when a file that is in the list cannot be found in the folder. I can only seem to get a message box to display after every file is moved so..20+ message boxes, or one at the very end regardless if anything has been moved or not


Here's (part) of my code:

Please Login or Register  to view this content.

Thanks!

Set a Counter... increment it when you move a file and if not 0 at the end then display the messagebox

Please Login or Register  to view this content.

This worked, thanks!