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.
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
Thank you, and also thanks for guiding me but before posting here i have tried alot to understand your sheet but could not.
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.