Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password userform
For a small VBA application, I need a password (PW) check.
I constructed a userform with 1 combobox for userlist, 3 textboxes (1 for old PW, 1 for new PW and 1 for validation) and 2 commandbuttons (cancel and OK). After the user select his name, he is allowed to enter his (old) PW in textbox1, followed by <enter. Imediatelly, his PW is checked (with exit event); if not correct he get a message and try again, if correct, the 2 other textboxes are enabled for text input. Problem; 1/ Entering the first textbox1 and checking password is OK, but after 1 failure of the PW check, I'm not allowed to push the cancel command (?). 2/ After entering the correct password, the cursor does not jump to textbox2, and that's what I want. 3/ The same procedures should go for textbox2 and 3 for checking minimal 3 characters of new and validated password. I did not do this yet because I can use approx the same code as for textbox1 (also exit event) What's wrong? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
password userform
Roland
You'll have to post the code. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Roland wrote: For a small VBA application, I need a password (PW) check. I constructed a userform with 1 combobox for userlist, 3 textboxes (1 for old PW, 1 for new PW and 1 for validation) and 2 commandbuttons (cancel and OK). After the user select his name, he is allowed to enter his (old) PW in textbox1, followed by <enter. Imediatelly, his PW is checked (with exit event); if not correct he get a message and try again, if correct, the 2 other textboxes are enabled for text input. Problem; 1/ Entering the first textbox1 and checking password is OK, but after 1 failure of the PW check, I'm not allowed to push the cancel command (?). 2/ After entering the correct password, the cursor does not jump to textbox2, and that's what I want. 3/ The same procedures should go for textbox2 and 3 for checking minimal 3 characters of new and validated password. I did not do this yet because I can use approx the same code as for textbox1 (also exit event) What's wrong? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Userform | Excel Worksheet Functions | |||
Password userform activate | Excel Discussion (Misc queries) | |||
Password protected userform | Excel Discussion (Misc queries) | |||
UserForm Password | Excel Discussion (Misc queries) | |||
Password Userform help !!!! | Excel Discussion (Misc queries) |