Thank you for the response,

That works great but I need to figure out one tweak. Once all the cells have been filled out once this automatically goes back to A1. It creates a loop. I need to be able to select any cell at random. There are other sections of the form that will be filled out afterward and I cannot get to them. Also, when updating information in one of these cells I need to be able to go directly to a cell.

I am very new to VBA. I was thinking an If statement along the lines of If cell B17 is blank, run this code, if cell B17 has any text, do not run this code (B17 will always be filled out by the user). That way when I open the form it will take me through these cells in order but once I have filled them out, I can move to another section or update these without getting stuck in the loop. Any suggestions.

Jason