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

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

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.

Bernie, thanks for the answer. I just find it a little annoying when
you filling in a "form" and then click on a macro button to email it
away, you always have to hit <Enter in the last field you enter
before the macro can be run. Now I understood why.