Cursor automatically jumping / moving to next cell

[christianntem]

Hello I need help trying to figure out to make excel 2013 cursor move automatically to next cell
Example. I type in the letter (A) in cell A1 and cursor would automatically move to B1
Thank you

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

Look in the Excel options.

Go to File-->Options-->Advanced.
At the top, under Editing Options, you will see a dropdown with all the options available. Select "Right".

Regards,

 

[christianntem]

Hi and welcome to the MrExcel Message Board.

Look in the Excel options.

Go to File-->Options-->Advanced.
At the top, under Editing Options, you will see a dropdown with all the options available. Select "Right".

Regards,

Thank you very much for the reply. I really appreciate it.
I forgot to mention that, I want the cursor to move without pressing ENTER or TAB key. Just move automatically to next cell after I type a single letter

 

[RickXL]

You may live to regret this but it is possible.

You will need to use some VBA. The code below needs to be pasted in to the code module for the sheet you want to use it in. E.g. Sheet1, Sheet2 etc.

Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    Dim r As Range
    With TextBox1
        .TopLeftCell.Value = .Text
        .Text = vbNullString
        Set r = .TopLeftCell.Offset(, 1)
        .Top = r.Top
        .Left = r.Left
        .Width = r.Width
        .Height = r.Height
    End With

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With TextBox1
        .Top = Target.Top
        .Left = Target.Left
        .Width = Target.Width
        .Height = Target.Height
        .Activate
    End With
End Sub

Whenever a cell is selected it places a TextBox in it that is the same size as the cell. Straight after your key press the character is copied top the cell, the TextBox is cleared and moves to the next cell across.

You will also need to go into the Developer Tab and insert an ActiveX TextBox into the worksheet, somewhere.
If you then select another cell with the mouse it should start working.

Regards,