Data entry commitment without hitting Enter key

[Why Tea]

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

 

[Bernie Deitrick]

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]

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.