How to force users out of edit mode?

[redrick]

I have users who don't press Enter (or move to a new cell) after
entering text. They then try to click a form button - and of course -
the macro does not run.
Is there an xl/vba solution to force them out of edit mode before
clicking the button?

 

[Corey]

Few ways to get around it.
.....
Add in the first part of the EXIT Code something like

Private Sub CommandButton1_Click()
CommandButton1.SetFocus
Sheet1.Range("A1").Value = TextBox1.Value
.... Othe code
Unload Me
End Sub

Corey....

I have users who don't press Enter (or move to a new cell) after
entering text. They then try to click a form button - and of course -
the macro does not run.
Is there an xl/vba solution to force them out of edit mode before
clicking the button?

 

[redrick]

Thanks Corey,
That will work on a form but not in a cell.
By form in the original post I meant a button from the Forms toolbar
not from the Control Toolbox.