Have macro wait while filling in auto-generated form

[GaretJjax]

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.

[rylo]

Hi

How are you raising the form? In the quick test I did, the macro waited until the form was completed before progressing....

rylo

[GaretJjax]

Rylo,

I never in a million years would have realized that I could just keep going with the code without any instruction whatsoever and the macro would just wait. Thank you for your help!!! (fyi, I go to Data-->Forms)