Have macro wait while filling in auto-generated form

This threat is to some degree a continuation of the thread here, but deals with an issue that is really separate, so I marked the prior thread [Solved] (it was here http://www.excelforum.com/excel-prog...ml#post1997753 )

My issue now is that when I run a macro, it takes me to a different sheet, clicks on a cell, and then goes to data--> form to automatically generate a form so I can make a new entry. I want the macro to wait until I have completed the form, and on completion to do something else. I'd prefer it if I could indicate completion of the firm by just a keystroke, but a mouse click will do as well.