VBA Sleep code time interval question

Thanks Jeff, I tested this out but it actually isn't changing the shapes color after I click "OK" on the message box that pops up when typing something into J34. It was changing the color before with the Application.Wait line but for this after clicking OK, it stays the same color and has a bit of a delay before you can click in another cell. That delay in being able to click was expected, but the lack of color change wasn't. Were you getting a different result?