You can try a workaround like:
Private Sub Worksheet_Change(ByVal Target As Range)
    Call CommandButton1_Click
End Sub
So when a user presses enter or tab after entering in the cell, it would be equivalent to clicking the button. You may want to also check if the Target is within a specified range where the user would enter data in.