Re: Password Input with limited Tries
Thanks Logit. It will work and I will have it for future needs. After reading some posts related to the issue and thinking about a simple way of doing it, a way came to my mind: way not to repeat the initialization of the form till it meets the numbers of attempt? It happens too fast that the user do not notice it and have the counter in the initialization of the userform. Well, I tried, and It Worked!!. Here it is the code in case someone else may use it. I appreciate all of your helps!.
This is the OK command button
Private Sub CmdOK_Click() Dim msb As String Dim username As String username = Application.username msb = frmMyPass.TextBox1.Value If msb <> Hoja8.Range("B28") Then iCounter = iCounter + 1 MsgBox (username & ": " & "Tienes " & 3 - iCounter & " intentos") TextBox1.Value = "" [COLOR=#FF0000] U[B]serForm_Initialize[/B][/COLOR] Exit Sub Else Unload Me Sheets("MENU").Activate Range("I2").Select End If End Sub
and this is the Initialization of the userform