Excel Userform Multi Level Login

Good Day

I have this Excel Userform, whereby two difference Departments are logging in to amend records.

The login box consists of two Textboxes - username and password.

When the user Logs I would the userform to protect(grey out) certain Textboxes and Menu buttons based on their Username.

Example:

Username: John
Password: 123
Department: Finance

Username: Jack
Password: abc
Department: Credit

If John logs from Finance, TextBox1 and TextBox6 must be disabled of hidden

If Jack logs in from Credit, TextBox1 and TextBox6 must be enabled however TextBox2 and TextBox8 must be disabled or hidden

Currently I am using two userforms to achieve the above which is not ideal.

Create a Boolean reference, which is marked True/False depending on the login, and then use the True/False to enable/disable the boxes.

Hi Kremxel

Can you please provide a sample code for the Boolean reference
thanks

Without seeing your current code and because i'm writing on my mobile on a train with intermittent connectivity I've created the pseudo code below for illustration purposes that should help,

in a module
public bFinance as Boolean

Please Login or Register  to view this content.