Okay guys, so now we're going to have an exercise for the input box. So we're going to create an input box that prompts the user for his password. So the password entered is my password, and this is case sensitive. So he needs to enter in this same casing, then a message box will be displayed saying Access granted, and if the password entered is incorrect, so if enters an incorrect password or he enters a blank password, or you or he presses cancel on the input box, then the message box having guests no buttons and VB question will be displayed saying invalid password Would you like to try again? Or try again? And if the user clicks, yes, the user will be put back to the first input box and get prompted for his password again.

And if the user clicks No, then we exit the sub. Now I'm going to demonstrate that macro for you because I've got it already here answered. And you can look at the answer if you get stuck. So I'm going to run it here. So please Enter your password if I enter an incorrect password here, and click OK. It says invalid password Do you like to try again?

If I click Yes, I try again. If I enter an invalid password again, and click No, try again and click No. Then we exit the sob. And if I enter the correct password here, my password correct one and click OK. Then access is granted. So this is the functionality that I need you to create. So please attempt that exercise and if you get stuck, have a look at the answer here on this exercise answer module.

And if you have any questions, please leave them in the q&a section. Thank you very much for watching this video and I'll see you on the next one.