Help with pausing macro

[c_granstaff]

Hello,

I'm somewhat of a newbie and have come across a problem. I have written a macro with a dde link and only want certain data placed in the cells. My app loops and reads continuous data and places each number in a new row. I need to pause the macro at the end of each loop cycle and then restart it (to record the new data). I need to be able to use keyboard entry to restart, preferably the space bar, but will settle for {enter}. I have tried SendKeys, but have not had any luck.

Thanks,

Curtis in Seattle

 

[Smitty]

Welcome to the Board!

Take a look at the Wait method in the VBA helpfile. It might be what you're after.

Or you could stall it with a Message Box.

Hope that helps,

Smitty