creating input cells in excel

[Pekka]

Hi there,
I wonder if it's possible to create after update event for cell in Excel. What I mean is: if I enter something in cell A1 after that cursor goes to cell D4 and so on.

Best regards

 

[GeekGirlau]

You can do this by protecting the cells.

1. Select the cells you want to enter data into
2. Select "Format", "Cells", "Protection"
3. Remove the tick for "Locked"

Now you need to protect the sheet.

1. Select "Tools", "Protection", "Protect Sheet"
2. Enter and confirm a password if you want - this is optional
3. Select OK

Now when you use your Tab key (not Enter) to move to the next cell, your cursor jumps to the next unlocked cell.

 

[Pekka]

Yes, I know that method but many users use enter key to put value to cell. I think I use your method + I put some code to worksheet_activate to automatically select the input cells and then it's no matter to use enter or tab.