Accept cell values with button click and without 'Enter' or 'Shift'

[davidam]

If I enter a value into a cell, I have to hit Enter or Shift before the program will accept a new value into the active cell. Is there a way to make it so that a cell will accept a new value with the click of any button and without the Enter or Shift key?
Thanks,
David

 

[GlennUK]

What do you mean by "any button"?

By the way Shift key doesn't confirm the entry of a value into a cell.

 

[Ruddles]

What do you mean by "what do you mean"? It's next to Alt:-

 

[GlennUK]

What do you mean by "what do you mean"? It's next to Alt:-

Oh yeah, there it is!

 

[davidam]

Sorry for creating this confusion. What I meant was: I want to be able to click a command button or a form button and have this exit me from edit mode.

 

[davidam]

PS...my question is not an April fools joke...unlike Ruddles answer!!

 

[Ruddles]

Explain what you mean by "any button".

 

[davidam]

I mean a form button or command button.

 

[Ruddles]

A command button on a worksheet, no, because you can't call a VBA procedure whilst in Edit mode.

If you're entering data into a text box on a user form, then yes - if you click a command button whilst entering data, the button will take focus, ending the data entry.

 

[davidam]

Thanks!