If ElseIf statement

on sheets 5 i have in column B a list of employees names. In column C I have 4 digit pass codes.
on the userform I have a combobox1 that list the names of the employees on sheet 5.
Below this I have a textbox1 for current pass code. under this another textbox2 for new pass code.
under this another textbox3 to confirm new pass word. What I am trying to do it if the two new pass codes <> the msgbox "Please try again". and allow the user to try again. here is what i have so far

Please Login or Register  to view this content.

I can not upload due to confidentiality with my company. Let me make this easy.
I need to know how to check if the value of two text-boxes match. If yes continue.
If no allow user to reenter the pass code and check it again.

Here is the best solution I can offer but without your file there is no way for me to test this and I have no idea if this will work with the rest of your code. Note that once the user enters this, he MUST enter two matching passwords. There is no way to quit.

Please Login or Register  to view this content.

6StringerJazzer,
That did not work. I have stripped down everything to the bare minimum.
See if this will help. It is not exactly like what I have but enough that I can use the help with my code.

I am not seeing the problem with the original. If the user enters two passcodes that do not match, they get a message and the form stays up--it allows the user to try again. If they exit the form, the passcode is not changed. This is pretty much the industry standard. What do you want to do different?

The benefit to using a GUI is that you have a lot more control over leading the user through entering input, and validation:

• Disable the Change Passcode button until the user enters the correct current passcode and two matching new passcodes.
• Do not allow the user to enter a new passcode until he has entered the current one correctly.
• Do not allow the user to press the button until he has entered a correct passcode and two matching new passcodes.

There is no need to insert a line in your sheet with the prompt, then delete after. You can add it directly to the combobox list when you load it.

Also, I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.

I have attached a rewrite that I think you will find gives a better user experience and greatly simplifies the code. You may have to address data types for your passcode field.

the problem is, I try with wrong pass code to make sure the error comes up. (It does)
the form stays up like I want.
But second time I type correct code and it will still say incorrect.

That does not happen when I do it. If I delete the incorrect code and type the right one, the error goes away and the other two boxes become active.

your code works. But when I run it on my program as I start to type the second pass code (the first new one) I get the error

I'm glad to help! If you have further questions on this specific problem please post them to this thread.

Thanks so much for your understanding and for all you have taught me.