Move to next cell

  • Thread starter Thread starter SFC Traver
  • Start date Start date
S

SFC Traver

I believe this might be possible, but I don't know how to do it. I have 24
cells in a row. I want to limit the values that can go in the cell to single
digits (0 through 6). I also want it to move to the next cell to the right
once a single digit is entered. At the last cell. I want it to return to the
first cell in the next row. Can I do it and how?
Thanks!
Dan
 
I dont really understand, but looks like to need to validate the input
(data>validation) and then have a macro triggerd on Worksheet_Change
to do the moving around.
 
To help, I have a workplace climate survey with 24 questions. People select
one answer per question on a scale of 1-6. I use this workbook to add all the
responses (usually 250-500 depending on the department) and do the
calculations and charts. Evrything works fine, I'm just trying to limit the
keystrokes I am doing when entering the raw data from the surveys.

So survey #1 starts at cell B2 for question #1 and moves to cell C2 for
question 2, etc until cell Y2, where I want it to go to cell B3.

I sorta understand what you said, but can you be more specific?
Thanks!
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Worksheet change: move to next cell 3
VBA set thick borders around non empty cells in range 0
For-Next by a row Counting consecutive Zero in the column 4
Search for empty cells and move cells next to 10
Concat a three column range into one cell Then Next... 2
Move to next cell automatically after typing one digit 2
Create if partial match then copy and paste data from one cell to another 1

Back
Top