cursor movement if no data entered

[Rodger]

G'day all,
I've been struggling with this, but I hope its as easy as something simple ...
In the attached sample, If data is entered under 'Notes' in column I, the cursor
properly goes to col G in the next row. The issue is if no data is entered under 'Notes'.
I would like the cursor to still go to Col G in the next row, instead of just going down a row
and staying in Col I.
Thanks in advance for taking a peek at this!
Cheers,

Rodger

 

[David Evans]

Try making the move contingent on the no of characters in both G&I cells being >1?

 

[NARAYANK991]

Hi ,

Since you are protecting your worksheet , if you can ensure that all the unwanted cells are locked , pressing ENTER without actually entering any data , will automatically move the cursor to the next unlocked cell.

If you do not want to do this , pressing F2 and then pressing ENTER will take the cursor to the wanted cell.

Narayan

 

[Rodger]

Hi ,

Since you are protecting your worksheet , if you can ensure that all the unwanted cells are locked , pressing ENTER without actually entering any data , will automatically move the cursor to the next unlocked cell.

If you do not want to do this , pressing F2 and then pressing ENTER will take the cursor to the wanted cell.

Narayan

Hi Narayan,
(there is no password, sorry it was protected).
The problem is that if ENTER is pressed with no data in Col I, it moves down a row, but still Col I, when I'd like it to go down a row, but back to col G.

Rodger

 

[NARAYANK991]

Hi Narayan,
(there is no password, sorry it was protected).
The problem is that if ENTER is pressed with no data in Col I, it moves down a row, but still Col I, when I'd like it to go down a row, but back to col G.

Rodger

Hi ,

If you will not be protecting your worksheet , then the only option is to press F2 and then press ENTER. That is the only way in which the Worksheet_Change event will be triggered , thus executing the Worksheet_Change event procedure ; this can then position the cursor where ever you want it.

If the ENTER key is pressed without entering either EDIT mode or fresh data , really speaking , no change has taken place , and the Worksheet_Change event will not trigger , and its associated procedure will not run.

Narayan

 

[Rodger]

Hi ,

If you will not be protecting your worksheet , then the only option is to press F2 and then press ENTER. That is the only way in which the Worksheet_Change event will be triggered , thus executing the Worksheet_Change event procedure ; this can then position the cursor where ever you want it.

If the ENTER key is pressed without entering either EDIT mode or fresh data , really speaking , no change has taken place , and the Worksheet_Change event will not trigger , and its associated procedure will not run.

Narayan

Ahh, ok, makes sense - I will be protecting it, but since the cell directly below
is unprotected, it automatically goes there.

Appreciate the explanation, and why no matter what I tried failed.
Thanks again!

Rodger