Lock cell in range(s) after input

Ho do I lock a cell after input?

I found this code

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

the password of the sheet is cream

But when the code is entered it generates an error "compile expected line number or label or statement or end of statement" and the cell is not locked when checked

how do i expand this code to include multiple row like b12;h12 and b26:h26

(I do not know if this is relevant
but the ranges b9;h9 etc are data validated to only accept certain specific values to be entered and the cells are configured not to display the entered values but just provide feedback in a different cell if it is correct)

I have tried variations of this code but all with the same error

I can run this code with no errors. Are you sure that what you put in your post is exactly what is in your file? I think there is something relevant that you are not including. What line of code is highlighted when this error occurs?

Do you want to check for every row in B:H or just certain rows? You don't need an intermediate variable, you can do this:

Please Login or Register  to view this content.

If you want all rows, then this:

Please Login or Register  to view this content.