Match Combobox with textbox then enable password: HOW TO?

Hello everyone.

I have been trying to look for working codes for the userform to work flawlessly. Unfortunately, I couldn't find any code. I just wish you could help me how to do this. I have a sheet named "DATABASE" with names of schools in column A, school ID in column B, and password in column C.

The combobox (cboStation) is populated already with the list of schools. What I need to do now is when a user select a specific school from the cboStation, the user can input the corresponding school id in the Textbox1. When Textbox1 matches with the selection in the cboStation, the password will be enabled. This means that when cboStation and Textbox1 don't match, the password area is disabled.

Below are the codes within the userform:

Please Login or Register  to view this content.

Hi Leith,

The school id serves as their username. If it matches with the name of the school, the password box will be enabled and the user can have access in putting his/her password. Each user who is assigned to specific school will be provided with his/her respective password.

I hope that this is clear.

Thanks.

Leith,

I hope someone from this forum could extend a help. MORE POWER to all.

Thanks.

I'm still confused by what you're trying to do...

So, step 1, user selects a school in the combobox.

Step 2, user enters the school ID. Are there multiple school IDs for each school, like one for each student? Can the same school ID be associated with more than one school, like if the same student takes classes at two different schools?

Step 3, if school ID matches the school, password field is "enabled"... does this mean that the password on your database list gets shown automatically in the textbox, or does this mean that the user can only enter a password if the school ID matches the school, and then the password entered will be compared to the password in the database to see if it is a match?

This is how it should work.

Step 1. User selects a school in the combobox.

Step 2. User enters the correct school id which matches the selected school from step 1. Each school has it own unique school id. No duplicate school id is provided to other schools.

Step 3. If the school id matches with the school in the combobox, a password field is enabled. The user then input his/her password to login (can have access to a specific sheet within the workbook). The password should also match to the provided password within the database.

Assuming you have 1 x ComboBox (cboStation) & 2 TextBox (TextBox1 & 2).
ID should be entered in TextBox1, and TextBox 2 for password entry.

Please Login or Register  to view this content.

jindon,

The codes you have provided was great. But I don't know how to integrate this one to LOGIN button. Anymore suggestion?

Thank you.

If you upload your workbook with the USERFORM, I can do it. otherwise too much GUESS work...

jindon,

Kindly check the attached file.

Thanks.

I don't understand after "LOG ON" click though...

Please Login or Register  to view this content.

jindon,

Sorry for not so specific.

Data for login:
Amalao Elementary School 120071 AES120071

The cancel button will close the entire workbook.
Once logon successful, the user will be taken to LOGON SHEET.

Refer to this.

1) Change Cancel button code to

Please Login or Register  to view this content.

2) Add following code to the module.

Please Login or Register  to view this content.

Thank you!

But there is one more thing I need if it would be okay. The user can only access its own worksheet after clicking LOGIN.

If you have another query, you should sate everything.

Asking one by one is not good.

Sorry! and thank you.

jindon,

It is assumed that all worksheets are available. Otherwise, a message will prompt "The worksheet is unavailable right now. Please contact the system administrator. Thank you." then the application will quit.

Don't worry, you opened a new thread, so continue there, someone will help you.