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" <(E-Mail Removed)> wrote in message
news:7481d47e-7f60-4e22-996b-(E-Mail Removed)...
> 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.