Data entry commitment without hitting Enter key
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 |
Data entry commitment without hitting Enter key
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 |
Data entry commitment without hitting Enter key
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. |
All times are GMT +1. The time now is 11:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com