unlock cells when previous cells are filled

You forgot to attach the file - see yellow banner at the top of the forum.

Be sure to manually add the results you expect to see and identify the results cells and the data cells

i AM UNABLE TO ATTACH THE FILE. I ahve already tried it once.

Reedit: Done. Got it

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for you this time: https://chandoo.org/forum/threads/un...-filled.47625/)

Originally Posted by vicky235

Ok. Let me try again

Thanks,

Unfortunately that doesn't help me a lot.

Please clearly explain which cells you want the user to complete. If the sequence is important then specify that too but it may not matter as long as all cells are completed at the end.

Then tell me what you expect as a result. It seems you want some cells locked / protected so be quite clear which ones and if there are conditions that control that process.

Incidentally I note you are using merged cells. For any serious application, particularly one involving macros you're better advised to avoid them like the plague (or covid). Most of us do since they just cause too many problems.

okay, Hi again. Here is an update. So far, i have done changes.
I still want to improve it but, I believe there are still some errors.
I further want to ensure that after a cell is filled the next cell selection should be predefined and a problem with checkbox still exists. I dont know yet but I am still working on this.
Here si a sample attached.
Thank you.