Home/ Questions/Q 3410
Next
Answered
computing
  • 7
Asked: 2021-11-03T13:41:37+00:00 In:

Enter Value In Cell, Move To Next Cell Without Enter Or Tab

  • 7

Hi Guys,
Have been looking to find the answer to this, but am getting no-where. Here is what I am trying to do.

I have a column of cells, from C1 to C9
I enter a value of between 0 and 9 in C1
Without hitting (Enter) or (Tab), we automatically jump to C2
I enter a value of between 0 and 9 in C2
Without hitting (Enter) or (Tab), we automatically jump to C3

and so on until the last value is entered into C9

I then click on a Forms Button and the information in C1 – C9 is pasted to another worksheet,
and the information in C1 – C9 is cleared ready, for the next lot of values to be entered.

Has any one got any ideas of how to go about this?

Share

    1 Answer

    1. Best Answer
      Thanks for responding.
      Your answer is what I have found in other Forums.
      However if the value of the entry is known, ie between 0 and 9 inclusive, is there someway around this. That a single entry (digit) has been made, and therefore move to the next required cell

      At the moment I am using data validation to ensure that the figure entered in the cells is between the criteria 0 to 9 inclusive, and then (Tab)

      • 0