You say move to a specific cell to trigger the form, but then you want the
form to react to the cell they are in. Wouldn't the cell always be the
"specifc cell" that triggers the action.

Is specific cell actually a cell on any row in a particular column. I thing
a clear explanation is needed.

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
In my macro, the user would to move to a specific cell.
When they hit the "Enter" key, I would like for a form to
open. The user would then enter data into the form based
on the line in the spreadsheet that they are in. Once they
enter all of the data, they would hit a button, the info
would be displayed on another sheet, the form would close,
and the cell on the next line would be active.

Is this possible? I'm having some trouble getting the
form to display when the "Enter" key is hit.

Any suggestions would be appreciated. Thanks..