VBA to jump to certain cell after changing contents of one

Question

I am creating a spreadsheet that I want to force people to input certain information. Is there anyway of forcing people when changing the contents of a cell that once return or tab is entered that it jumps to another cell.

For Instance:

CELL C2 (Date)         01/01/2001
CELL C4 (EMPTY)        JUMP HERE

So above I want someone to enter a date in C1 and when they change this is jumps to C3.

Kris

[THIS](https://stackoverflow.com/questions/13860894/ms-excel-crashes-when-vba-code-runs/13861640#13861640) will get you started — Siddharth Rout, Jun 27 '17 at 07:30
If you protect the sheet and only leave the cells you want to be changed unlocked then tab will move to the next unlocked cell, provided you tick the correct restrictions for locked cells — Jordan, Jun 27 '17 at 07:30

score -2 · Answer 1 · edited Jun 28 '17 at 22:16

-2

The selection of a specific cell in the first sheet:

ThisWorkbook.Sheets(1).Range("A2").Select

You can use name of the sheet as a string instead of 1 in sheets(1)

edited Jun 28 '17 at 22:16

EBH

10,350
3
34
59

answered Jun 27 '17 at 08:36

DannyFrank

9
4

VBA to jump to certain cell after changing contents of one

1 Answers1