All right I have uploaded the sheet that I am currently working on. First, the second code worked so I want to thank you Kelshaer. My first problem now is that when any cell becomes "pending" in column F, I would like the date entry code to execute corresponding to the cell that become pending (so if cell F10 became pending, A10 would pop up the date prompt), otherwise the code won't execute at all. I hope that help clear up some confusion anyone might have.
Bookmarks