Locking cells based on another cell's input

I need help with a code. i need to select between 4 choices which are named in A1,A2,A3,A4 while the selection of these choices by typing either 1 or 0 is in B1,B2,B3,B4. What I would like the code to do, is when 1 is typed in B1, the other cells, B2,B3,B4 are locked. Likewise for selection of B2, which will result in the locking of B1,B3,B4.

If possible, an IF function would be good! a VBA code would also do but i'm not too good at it so pardon me for asking for an explanation! THANKS SO MUCH!

Hi friscer

Welcome to the forum.

Would you need the ability to change your mind? Having entered something in (say) B1 would you need to change that to a B2 entry (because, of course, it will not be alllowed if it is locked).

An easy way would be to use a bit of VBA to lock all 4 cells once any of them have an entry. You could then have a system to unlock (but this might defeat the object of locking in the first place)

Regards
Alastair