Moving through a data entry form

  • Thread starter Thread starter jjankowski
  • Start date Start date
J

jjankowski

I am trying to create a form that will take the user to the next fiel
after entering data. I have tried to record a macro using "Got
Reference", but it doesn't stop and wait for user input. I need bot
the event procedure and the correct format for incorporating it int
the macro. thank you
 
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.
 
Back
Top