You can try a workaround like:
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.![]()
Private Sub Worksheet_Change(ByVal Target As Range) Call CommandButton1_Click End Sub
Bookmarks