Im using the following code on a User login userform. This code is for the Login command button to access the workbook (the user clicks on it after entering there username and password).
For some reason if the password is numbers only it just returns message box "Incorrect password, please try again."
As soon as I put a single letter into the password it works fine, I can't figure out why.
Please Login or Register to view this content.
Just a thought, you have declared PW as a STRING. I think that when excel sees a number, it says it is not valid!
Try removing the "as String" from the Dim statement. Excel will then treat it as a Variant, and allow anything to be entered.
Please let me know if this works!
Regards,
David
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
Thanks for the response David, but that didn't seem to affect it.
Hi James,
I think your problem may be in the Spreadsheet and not in the UserForm. I think you should probably format the Spreadsheet cells as text. Without previous formatting text is displayed as left justified and numbers are displayed as right justified in the spreadsheet.
1. You might want to try retrieving the data from the Spreadsheet as text. In my applications that require numeric values in cells, I usually read them as text first and then convert to numbers in order to catch bad values in the spreadsheet without having to use 'on error'.
Try replacing:with something like:Please Login or Register to view this content.
Please Login or Register to view this content.
2. Alternatively, without modifying the spreadsheet, you could convert both the actual password and the user entered password to strings such as:
If this doesn't work there are more complicated scenarios that you can use.Please Login or Register to view this content.
Lewis
Last edited by LJMetzger; 03-23-2014 at 11:13 PM. Reason: Added alternative 1. after thinking more clearly; aternataive 2 was in original.
Thanks Lewis, that first option your gave me works just fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks