I have a form that has 20 text boxes that are populated from a spreadsheet. The text boxes are populated with names of .pdf files. What I'm trying to do is print the contents of the text boxes. There needs to be a 5 second delay between each print. What I tried to do is use the application.wait to pause for 5 seconds and then loop through until each text box has been printed. After I have printer the contents of a text box I'm changing the back colour to green. The problem I have is when I try to print the first box goes green and then when all are complete the others go green. I can't get it to go green after every 5 second delay.