Activate Cells after Data Entry @A1 or Cell 1

[Closed]
Report
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
Hello Guys,
Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input characters 12345 or ABCD at cell A1 then the next cell shall now on its activated state; however, if no text was filled by the user then the next cell should be disabled.


BR,
Maden

1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
Hi Maden,

Once you have unblocked cell A1 and protected your sheet, then use the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect
Target.Offset(1, 0).Locked = False
ActiveSheet.Protect
End Sub


Best regards,
Trowa