Hi i have a username and password textbox and i want to know when i enter a correct username the textbox it is in turns green and when wrong it will turn red, here is the code i have so far im not very experienced but know bits and pieces.
Code for txtpassword.text
Code for txtusername.text
Please Login or Register to view this content.
any help would be brill thanks.Please Login or Register to view this content.
Last edited by lvlister2005; 04-11-2007 at 02:12 PM.
Please someone must know.
Are the text boxes attached to the sheet, or on a user form? Also, what type of text boxes are they (inserted from forms toolbar, controls toolbar, or picture toolbar)?
They are on a user form and they have been inserted suing the insert menu in the developer section in excel 2007.
In which event handler procedure is this code written? Try this:
HTHPlease Login or Register to view this content.
Jason
Last edited by jasoncw; 04-11-2007 at 06:37 PM.
Thank you worked like a treat 1 final thing i was wondering how do you make the the first letter of a username be forced to be uppercase using the code you provided thanks again.
Do you mean you want the first letter to change to upper case in the text box, or do you want VBA to recognize the first letter as uppercase for the tryUserName variable?
I want the username to be uppercase is the tryusername variable,
This code will automatically create proper case in the text box itself:
This code will not change the case in the text box, but it will assign proper case to the variable:Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
Jason
Again very helpful thanks so much, have a good day!!
No problem. Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks