There is no provision in Excel VBA to stop and wait while the user enters
something in a cell.

You will need to prompt with an input box or userform to get the input, then
place it in the cell with your code.

An Alternative is to halt the macro and try to trap the activity of the user
to determine when to continue.
--
Regards,
Tom Ogilvy


jjankowski wrote in message
...
I am trying to create a form that will take the user to the next field
after entering data. I have tried to record a macro using "Goto
Reference", but it doesn't stop and wait for user input. I need both
the event procedure and the correct format for incorporating it into
the macro. thank you!


---
Message posted from http://www.ExcelForum.com/