P PhyllisTheCat Jul 16, 2008 #1 Would appreciate if someone can help. I want to have the cursor skip one row after hitting the enter key. Thanks.
Would appreciate if someone can help. I want to have the cursor skip one row after hitting the enter key. Thanks.
B Bernie Deitrick Jul 16, 2008 #2 Phyllis, Try this event code. Copy the code, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Private Sub Worksheet_Change(ByVal Target As Range) Target(3).Select End Sub I've assumed that when you are 'hitting the enter key' you are entering a value into a cell. HTH, Bernie MS Excel MVP
Phyllis, Try this event code. Copy the code, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Private Sub Worksheet_Change(ByVal Target As Range) Target(3).Select End Sub I've assumed that when you are 'hitting the enter key' you are entering a value into a cell. HTH, Bernie MS Excel MVP
