Stay In The Loop With VBA

What is the difference between a recorded macro in Microsoft Excel and a VBA written procedure? The answer-None, as all Excel is doing when you record a macro is translate each keystroke or mouse click to VBA. There are a few operations that cannot be recorded in a Macro. The first is that a Macro cannot stop to accept user input, like a dialog box, input box or message box. Secondly, a recorded macro starts executing the VBA code in the procedure line by line until it reaches the end. It cannot perform a loop and re-execute the same code again. It's these loops that we will examine in this article.

The full article appears here:
http://www.microsofttraining.net/article-618-stay-in-loop-with-vba.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com