MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro Question


Posted by Angel on February 06, 2002 12:56 AM

How do I get a macro to pause, enter data & then continue? For example, say I want to go to A50, enter a name (which will be a different name every time I run the macro) & then go to another cell & repeat, etc.? What would the code be? Any and all help would be appreciated. Thank you.

Angel


Posted by Keiser on February 06, 2002 9:34 AM

Look at the timer function in VBA help, it works.

Posted by Angel on February 06, 2002 1:11 PM

Re: Look at the timer function in VBA help, it works.

Thanks Keiser... I'll give it a shot!

Angel