Automatically Moving from Cell to Cell when Entering Data

[pmeghnathi]

A1 cell value 12345678 (8 any character number) to auto move a2.than a2 any value ENTER hit key enter to move a2 cell continue this one by one 2 column

Move cursor

 

[Oaktree]

I don't know what you mean by

"than a2 any value ENTER hit key enter to move a2 cell"

Do you mean that you want the cells to go from A1 to A2 to B1 to B2 to C1 to C2 etc each time you confirm an entry with ENTER?

If so, just select A1:X2 (where X is the last column in your data entry) before you start entering the values.

 

[pmeghnathi]

I don't know what you mean by

Do you mean that you want the cells to go from A1 to A2 to B1 to B2 to C1 to C2 etc each time you confirm an entry with ENTER?

If so, just select A1:X2 (where X is the last column in your data entry) before you start entering the values.

Yes,but A1cell 8 character typeing to auto move without any key,and after B2 cell any value typeping ant hit Enter key to move A2

 

[pmeghnathi]

I don't know what you mean by

Do you mean that you want the cells to go from A1 to A2 to B1 to B2 to C1 to C2 etc each time you confirm an entry with ENTER?

If so, just select A1:X2 (where X is the last column in your data entry) before you start entering the values.

Yes,but A1cell 8 character typeing to auto move without any key,and after B2 cell any value typeping ant hit Enter key to move A2

 

[Oaktree]

It's not possible as you've described it for the simple reason that you cannot run a macro while in edit mode.

That said, you might consider the textbox approach @Jonmo1 explains here: Move to Next cell AFTER certain # of characters are entered.

 

[pmeghnathi]

It's not possible as you've described it for the simple reason that you cannot run a macro while in edit mode.

That said, you might consider the textbox approach @Jonmo1 explains here: Move to Next cell AFTER certain # of characters are entered.

What is this code
Private Sub Worksheet_Change(ByVal Target As Range)
Dim A As Range, L2 As Long, Leftover As Long
If Target.Count > 1 Then Exit Sub
Set A = Range("A:A")
If Intersect(Target, A) Is Nothing Then Exit Sub
v = Target.Text
L2 = Len(v) / 5
Leftover = Len(v) - 5 * L2
j = 1

Application.EnableEvents = False
For i = 1 To L2
Target.Offset(i - 1, 0).Value = Mid(v, j, 5)
j = j + 5
Next i
If Leftover = 0 Then
Else
Target.Offset(L2, 0).Value = Mid(v, j)
L2 = L2 + 1
End If
Target.Offset(L2, 0).Select
Application.EnableEvents = True
End Sub

 

[Oaktree]

The general approach to that is that the user would enter a very long string in one cell and the macro then splits that long text entry into pieces that go into different cells.

You could consider that approach as well, but the only way to type X number of characters and have it move to the next entry after X is reached is the textbox idea.

 

[pmeghnathi]

The general approach to that is that the user would enter a very long string in one cell and the macro then splits that long text entry into pieces that go into different cells.

You could consider that approach as well, but the only way to type X number of characters and have it move to the next entry after X is reached is the textbox idea.

This possibel
A1cell type value hit enter,and after B1 cell any value typeping ant hit Enter key to move A2 and after b2 .........

 

[Oaktree]

Select A1:B100 (or whatever the end of your range is).

After you enter the value in A1, press TAB instead of ENTER. That will move A1, B1, A2, B2, A3, B3 etc. instead of A1, A2, ..., A100, B1, B2, ..., B100 like using ENTER will.

 

[pmeghnathi]

Select A1:B100 (or whatever the end of your range is).

After you enter the value in A1, press TAB instead of ENTER. That will move A1, B1, A2, B2, A3, B3 etc. instead of A1, A2, ..., A100, B1, B2, ..., B100 like using ENTER will.

By vba code