Identifying user

Craig AS · Mar 18th, 2002, 09:18 AM

I have been working on a password entry system, But i need it to use a number of diffrent valid password, which can change every time another user signs up. I currently have this:

If strPass = "password" Then
MsgBox "Log in OK!"
Run "signin"

But there is only one valid password available, i have tried adding extra passwords using comas, but nothing i've tried has worked. Plus i need the system to update all valid passwords 4 each time some1 signs up. All passwords are stored in colum I2 onwards. I have been working on this 4 ages. Please help, even itf its a little help, any thing will be appreciated thanks,

Craig

canablitz · Mar 18th, 2002, 09:33 AM

well, craig, i know exactly what your problem is. what you need is a system to log all passwords and the usernames, and then record that as a macro. but as everyone hates you, no-one is gonna do it for you, HA HA BILLY!!!! go find some friends you lonely pOO!!!

Craig AS · Mar 18th, 2002, 11:08 AM

please? no1 has any help?

KniteMare · Mar 18th, 2002, 02:08 PM

Your "PassWord" needs to be a variable.
Then you need to ID the user. you could get this info from a msgbox: then compare the info recieved to a list using a loop through the range of User Names on a veryhidden sheet. You could then use OffSet to place a password in the cell next to the user name (Have them do it twice to confirm).(Write this in a new user valadation routine so that you can regulate who gets a password.)

Once they have a password and you've moved it to the list: Then your code would ask for username: if it exists it would ask for password: and compare this to the infor next to the user name and allow the user to proceed.. if not it would deny access. You can even set it up for say,,,Three tries and Excel will quit.

I can write this but it would be time consumming, and you would not have the oportunity to enjoy the learning experiance

I hope this jumpstarts you.

Use the help files in the VBE they are extensive and with patience you should be able to figure it out.

Yours in
EXCELent Frustration
KniteMare

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 09:18 AM	#1
Craig AS Join Date: Mar 2002 Posts: 26	I have been working on a password entry system, But i need it to use a number of diffrent valid password, which can change every time another user signs up. I currently have this: If strPass = "password" Then MsgBox "Log in OK!" Run "signin" But there is only one valid password available, i have tried adding extra passwords using comas, but nothing i've tried has worked. Plus i need the system to update all valid passwords 4 each time some1 signs up. All passwords are stored in colum I2 onwards. I have been working on this 4 ages. Please help, even itf its a little help, any thing will be appreciated thanks, Craig

Mar 18th, 2002, 09:33 AM	#2
canablitz Join Date: Mar 2002 Posts: 19	well, craig, i know exactly what your problem is. what you need is a system to log all passwords and the usernames, and then record that as a macro. but as everyone hates you, no-one is gonna do it for you, HA HA BILLY!!!! go find some friends you lonely pOO!!!

Mar 18th, 2002, 11:08 AM	#3
Craig AS Join Date: Mar 2002 Posts: 26	please? no1 has any help?

Mar 18th, 2002, 02:08 PM	#4
KniteMare Join Date: Mar 2002 Location: Hilo, Hawaii Posts: 240	Your "PassWord" needs to be a variable. Then you need to ID the user. you could get this info from a msgbox: then compare the info recieved to a list using a loop through the range of User Names on a veryhidden sheet. You could then use OffSet to place a password in the cell next to the user name (Have them do it twice to confirm).(Write this in a new user valadation routine so that you can regulate who gets a password.) Once they have a password and you've moved it to the list: Then your code would ask for username: if it exists it would ask for password: and compare this to the infor next to the user name and allow the user to proceed.. if not it would deny access. You can even set it up for say,,,Three tries and Excel will quit. I can write this but it would be time consumming, and you would not have the oportunity to enjoy the learning experiance I hope this jumpstarts you. Use the help files in the VBE they are extensive and with patience you should be able to figure it out. Yours in EXCELent Frustration KniteMare