pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
i have user form name "Userform1"
lebel1 with caption Username
lebel2 with caption password
textbox1 is to enter username
textbox2 is to enter password (i pressed f4, and in properties i have placed * next to PasswordChr) which shows only ***
when i enter the password:
I have a commandButton2 named cdmenter (to click after entering username and password).
I also have commandButton2 name cmdclose (to cancel if i dont want to log on to excel).
I need a code that if i dont enter unsername = "v456i" & password = "jiz21l"
msgbox "wrong info entered" "do you want to try again?" Options yes/NO
if yes selected then go back and give another chance to enter or if no selected then triger cancel and close the worksheet.
If anyone could help then, I will really appriciate it. Thanks.
Thanks again for helping!
![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
lebel1 with caption Username
lebel2 with caption password
textbox1 is to enter username
textbox2 is to enter password (i pressed f4, and in properties i have placed * next to PasswordChr) which shows only ***
when i enter the password:
I have a commandButton2 named cdmenter (to click after entering username and password).
I also have commandButton2 name cmdclose (to cancel if i dont want to log on to excel).
I need a code that if i dont enter unsername = "v456i" & password = "jiz21l"
msgbox "wrong info entered" "do you want to try again?" Options yes/NO
if yes selected then go back and give another chance to enter or if no selected then triger cancel and close the worksheet.
If anyone could help then, I will really appriciate it. Thanks.
Thanks again for helping!