YT,

You cannot start a macro when in edit mode:

"When the user enters data into a cell and click on a macro button"

You could use a macro that shows a userform with a textbox, and use that to enter the values into a
cell.


HTH,
Bernie
MS Excel MVP


"Why Tea" wrote in message
...
When the user enters data into a cell and click on a macro button, is
there a way to program a macro so that the data is committed (as if
the user has hit <Enter) when it is run?

/Why Tea