For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Course Of The Month
5 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Data Entry Macro Excel
Posted on 2014-03-20
I am looking to create what I think is a simple data entry macro for the following situation..Its obviously more complex than I can work out Though
A B C D
1 1 67 34 24
2 12 62 37 21
3 23 57 40 18
4 34 52 43 15
5 45 47 46 12
6 56 42 49 9
7 67 37 52 6
8 78 32 55 3
The first column is a record ie Record 1,2,3 4 etc
I want to enter the data into record 1 to start with so I enter data at A1 and when I enter the cell automatically moves to B1 then when I enter a number there it moves to C1 then D1
When I enter data into D1 it moves to cell A2 so I can repeat the process for that record and so on
essentially after I have entered data into a cell it moves to the right and needs to pause whilst I have time to select the next data to enter
Thank You in Advance Everybody
A B C D
1 1 67 34 24
2 12 62 37 21
3 23 57 40 18
4 34 52 43 15
5 45 47 46 12
6 56 42 49 9
7 67 37 52 6
8 78 32 55 3
The first column is a record ie Record 1,2,3 4 etc
I want to enter the data into record 1 to start with so I enter data at A1 and when I enter the cell automatically moves to B1 then when I enter a number there it moves to C1 then D1
When I enter data into D1 it moves to cell A2 so I can repeat the process for that record and so on
essentially after I have entered data into a cell it moves to the right and needs to pause whilst I have time to select the next data to enter
Thank You in Advance Everybody
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
2-
2
- +1
7 Comments
Active today
HI,
You could do it by selecting Col A to D (Highlighted) and by changinging the entry direction
in File / Options / Advanced / Afterpressing Enter, Move selection and choose Right
Regards
You could do it by selecting Col A to D (Highlighted) and by changinging the entry direction
in File / Options / Advanced / Afterpressing Enter, Move selection and choose Right
Regards
That would work but didn't address of how you get to the first column in the next row.
Since posting this I realised by watching some videos on You tube that a combination of
Input Box
ActiveCell.Value
Offset command ..which can move the next entry left, right, up down etc
Looping
will do the job.
for instance a macro like the one below would do the jobs.
Thanks for your thoughts.I had never realised you could what you suggested.
Dim i As Integer
Do While (i < 10)
i = (i + 1)
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(0, 1).Select
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(0, 1).Select
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(0, 1).Select
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(1, -3).Select
Loop
Since posting this I realised by watching some videos on You tube that a combination of
Input Box
ActiveCell.Value
Offset command ..which can move the next entry left, right, up down etc
Looping
will do the job.
for instance a macro like the one below would do the jobs.
Thanks for your thoughts.I had never realised you could what you suggested.
Dim i As Integer
Do While (i < 10)
i = (i + 1)
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(0, 1).Select
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(0, 1).Select
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(0, 1).Select
Answer = InputBox("number")
ActiveCell.Value = Answer
ActiveCell.Offset(1, -3).Select
Loop
Active today
HI,
let's try to select "A1" to "B2" the 3 cells are blue and one the active cell is in white enter your data and Enter it goes to A2 if Direction down then goes to next time it goes to B1 and then to B2
but if you want a macro try ( the activecell must be in col A to D
let's try to select "A1" to "B2" the 3 cells are blue and one the active cell is in white enter your data and Enter it goes to A2 if Direction down then goes to next time it goes to B1 and then to B2
but if you want a macro try ( the activecell must be in col A to D
Sub Macro()
Answer = InputBox("number")
Do While Answer <> ""
ActiveCell = Answer
If ActiveCell.Column = 4 Then
ActiveCell.Offset(1, -3).Activate
Else
ActiveCell.Offset(0, 1).Activate
End If
Answer = InputBox("number")
Loop
End Sub
Or using the Worksheet Change event and Move right after enter. This also allows for undo:
This also just enters straight into the cell rather than an input box.
Thanks
Rob H
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 5 Then ActiveCell.Offset(1, -4).Activate
End Sub
This also just enters straight into the cell rather than an input box.
Thanks
Rob H
If you try to select beyond column D, this will tke you back to column A in the next row:
Rob H
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column > 4 Then Cells(ActiveCell.Row + 1, 1).Activate
End Sub
Rob H
Featured Post
![[Webinar] Code, Load, and Grow](https://filedb.experts-exchange.com/files/public/2017/4/5/f91bafda-e65e-40df-8595-dc0d8c14c6d6.jpeg)
Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article will show you how to use shortcut menus in the Access run-time environment.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Suggested Courses
Course of the Month5 days, 10 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.