Hey everyone,
Trying to get a "password change" UserForm 'submit' button to find the record with the correct user, and change the password based on the users new input. I (think I?) have everything working except for the password doesn't change. Any thoughts?
Updated to fix code tags.
Please Login or Register to view this content.
Last edited by ericbartha; 04-01-2015 at 03:00 AM. Reason: Fixed code tags
Check the logic on your code
It appears you simple exit the do loop if usename and old password match.Please Login or Register to view this content.
You also change the password is new equals verify, regardless of username.
Thanks Andy, I will take a look. It's been a long day
The username is defined by a "login" userform when the workbook first opens which then locks in that user until the workbook is closed. Not worried about the username for this userform because of that.
Thanks again, hopefully I can work this out.
Hopefully the adjusted indenting of the code I posted will make it clear why the code is not functioning as you expect.
I am still new to VBA, so I am still not quite grasping it.
My thought for exiting the Do Loop is because it is after the line:
which would mean (if the value for the cell were changed) the password would be changed and purpose of the userform's purpose would be complete. I do not think I understand the logic of VBA well enough to figure out why this just isn't so. Any literature or advice you could point me towards?Please Login or Register to view this content.
Maybe I just need to go to bed! haha
Untested but should work,
Please Login or Register to view this content.
Sure does work!
Thank you very much sir. I will read through and compare carefully tomorrow. For now, bed time!
Have a good day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks