A non-modal form  can reactivate the active cell. Just

Private Sub UserForm_Activate()
ActiveCell.Activate
End Sub

Seemingly meaningless code, but it does the job (in 2003 anyway).

The form will still be visible, but the sheet will have the focus.