VBA Code to lock and unlock cells.

My problem is a have drop down box where the user selects a certain number of boxes to input data (example 3) and the code should prevent the user from entering data into all remaining boxes except the first 3. The code works if I select say box 4 or 5 before selecting box 3. However, after I select box 3 all of my boxes unlock and the use can now enter data in boxes 4 and 5. My code is below. Please advise where my logic has gone arrye

Please Login or Register  to view this content.

Moderator's Note: Welcome to the forum. Nice to have you with us. Btw when posting codes be sure to enclosed it with code tags. Highlight the codes then select the "#" symbol. Thank you.