title: Coding the Enter Key
body: <p>I am new to using excel macro editing. My spread sheet is based on inputting team scores. I have 4 columns. Column A and C are the team #'s and Columns B and D are their scores. So I want to make it so when pressing the enter key in cell B2 instead of going down to B3, it goes two to the right, to D2. and After going to D2, going to B3. I have 4 rows of teams so it continues all the way to D6. I tried using a macro but It was unsuccessful.</p>
  <p>That is what I tried but it didn't work. I need some sort of automated way for when pressing enter to select a cell using the Visual Basic Code. <a href="https://i.stack.imgur.com/xNJvu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xNJvu.png" alt="My unsuccessful attempt, I tried using an If statement, If Range(&quot;B2&quot;).Value &gt; -1 Then Range(&quot;D2&quot;).Select, but when repeated multiple times it did not work." /></a></p>