macro that waits for prompt
 

I am giving a lecture in excel. I want to write a macro that has the data I
want on the spreadsheet. I want the macro to enter the data in one cell and
then wait for my prompt (enter) to go to the next cell. Any help

macro that waits for prompt
 

Excel VBA doesn't support that directly. There is no wait for entry
command.

--
Regards,
Tom Ogilvy

"Bill" wrote in message
...
I am giving a lecture in excel. I want to write a macro that has the data
I
want on the spreadsheet. I want the macro to enter the data in one cell
and
then wait for my prompt (enter) to go to the next cell. Any help

macro that waits for prompt
 

How about using a MsgBox?

RBS

"Bill" wrote in message
...
I am giving a lecture in excel. I want to write a macro that has the data I
want on the spreadsheet. I want the macro to enter the data in one cell
and
then wait for my prompt (enter) to go to the next cell. Any help