Please help need a cell to remain blank until after pwd is entered in drop down (vba code)

Hi Excel Gods and Goddesses! i am back.. I am still new to the forum, so please forgive me if i have broken any rules. If you point them out to me, i will be sure to not make the same mistake!

So i need some expert assistance -

i have a vba code that prompts the user of my spreadsheet for a password when selecting from a drop down list (data validation).
I need a secondary cell to remain blank - i.e. not calculate/execute the formula until AFTER the correct password has been entered.

Any guidance is super super appreciated!!! code is below

Please Login or Register  to view this content.

Hi! Thank you so much for responding.. I was typing quickly to remove sensitive data.
Here it is corrected -

Please Login or Register  to view this content.

Thank you so much for your assistance! i super appreciate it. Sadly, it didnt work. I just done know if it can be done
But i truly appreciate you trying!!

Absolutely! Here it is. I tried to depict what i need to happen. Basically - in cell B6 is a drop down list of customer names. I have a set of passwords assigned to each customer. They should select their name from the drop down and be prompted to enter their password. This password should allow that specific customer to see their specific discount in cell F31. The issue is that once the drop down list is no longer "select", the cell F31 is calculating the discount regardless of the password being entered. I need to have either the cell B6 remain at "Select" or cell F31 to not calculate until after the correct password is entered.
I still want to thank you for you taking the time to help me. I really cant express my appreciation!

OK... i think i understand what you are saying. But how do i do that?

I am sorry if i am being dense. I am not a programmer and have had to learn what this is very quickly.
I had never seen VBA until i was handed this project.. So i am not entirely sure what you are asking.
I need cell F31 to not calculate until after the correct password has been entered. Currently, it is calculating no matter what password is entered.
It is quite possible that there are errors in functionality with the drop down password code as well. If you see where there could be improvements, please let me know. I am totally open to suggestions! Again, thank you so much!