Forced Tab event on close or save UserForm

G'Day Folks,

What I experience with UserForms I have created, that a failure mode occures and that is when users close or save the UserForm the last entry is not moved over from the form to the worksheet cell. This is simply because I operate with .ControlSource property and it requires to either click on another textbox, or to hit the Tab key in order the entries are transferred to the respective cell of the worksheet. And this is what users do not do, they just close the form.
So what I am now asking for is a line maybe in the UserForm_QueryClose sub that is actually an event of like hitting the Tab key.
Hope that is clear enough.

Thanks

Gabor

There are 4 commandbuttons on the form: Close, Print, Save and Create New.
All are to have that functionality to tab out of the last active control.
Also, the user can hit the x in the upper right corner. That is the why I thought one magic line in the private sub UserForm_QueryClose would do it all.
An OK button I do not have.