ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Login User Form (https://www.excelbanter.com/excel-worksheet-functions/394002-login-user-form.html)

benjaminr

Login User Form
 
Hi
On a userform being used as a Login, I have two textboxes...txt1 & txt2. and
Commandbutton1 = Login Commandbutton2 = Cancel.
My staff member will use txt1 for the UserName & txt2 for the PassWord. The member of staff will use Commandbutton1 to Login once username and
password is correct from a sheet containing list of login details. They will use Commandbutton2 to Quit the Workbook and it should not give the user the option to Save before exiting at this point.

what code do i use to make this work?

When staff type in the correct username and password - this data is
store in sheet (master) - (column A = Username, column B = Password, column C = linked sheet) it will open the worksheet related to that un and pw.

if username or password is incorrect a message will appear saying "Please
check the username or password is correct"

Also the cross ( X ) button on the TOP RIGHT HAND CORNER of the userform
should be disabled - so it stops the user from clicking the X to enter.

Maximum users is 15

I have used previous coding from this forum, but cannot seem to get it to work. If anyone can help me with this, it would be muchly appreciated. Can someone help with code and instruction where i need to input the codes?

GS[_2_]

Login User Form
 
Firstly, you should ALWAYS post the code you claim "doesn't work".

Secondly, the 'X' button on the userform's title bar does not fire the
keyboard 'Enter' event; it simply closes the userform.

Finally, you might find what you need here...

http://spreadsheetpage.com/index.php/site/tips

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc




All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com