I have made this Userform and want to add password reset code to initiate it but do not know how. please help.
After reset, the new password should be written on "Expense Sheet" under Password head automatically.
username: shoaib1
Password: password
I have made this Userform and want to add password reset code to initiate it but do not know how. please help.
After reset, the new password should be written on "Expense Sheet" under Password head automatically.
username: shoaib1
Password: password
This should help
This is the code that amends the password. You cannot learn VBA if you don't try to understand examples that are given to you.
Private Sub cmdUpdate_Click()
With Me
If .tbxNewPassword.Text <> .tbxConfirm.Text Then
MsgBox "New password & confirmation password do not match", vbCritical, "Input error"
.tbxConfirm.Value = Empty
.tbxNewPassword = Empty
Else: Sheet1.Range("users").Cells(lRw, 2).Value = .tbxNewPassword.Text
End If
Unload Me
End With
End Sub
Display More
Thank you, and also thanks for guiding me but before posting here i have tried alot to understand your sheet but could not.
Try this
I have added the password character to mask the input.
I've also moved the passwords to the admin panel sheet
Thank for your efforts but sheet is not getting open via login password.
I got it thank you so much
I entered code to change the password which is what you asked for. It made no sense to put the passwords into the expenses sheet.
Basically, you cannot be bothered to look at my example but want me to correct all the code in your workbook!
I did it thank you.
Don’t have an account yet? Register yourself now and be a part of our community!