Hello,
I have a multipage userform set to open on page(0). I'd like to try to limit what other pages and controls are enabled based upon a user's location and access level. On page(0) I set up a combobox of userid's and a text box where the user can enter a PIN number. I'm using a dynamic named range in the RowSource of the combobox and it points to column A of worksheet(1). The userid, PIN, Location, and Access level are stored in columns A through D for each userid (about 30 rows of entries).
After the user selects their userid in the combo box and enters their PIN in the text box, I'd like to try and have the system find and validate them against the worksheet and then enable either page(1), page(2), or page(3) of the multipage control based on their location in column 3, and also, if they have an Access Level greater then 2, then enable a command button found on page(0).
There are four possible locations and only two possible Access levels.
How would I set up such a validation process?
I have a multipage userform set to open on page(0). I'd like to try to limit what other pages and controls are enabled based upon a user's location and access level. On page(0) I set up a combobox of userid's and a text box where the user can enter a PIN number. I'm using a dynamic named range in the RowSource of the combobox and it points to column A of worksheet(1). The userid, PIN, Location, and Access level are stored in columns A through D for each userid (about 30 rows of entries).
After the user selects their userid in the combo box and enters their PIN in the text box, I'd like to try and have the system find and validate them against the worksheet and then enable either page(1), page(2), or page(3) of the multipage control based on their location in column 3, and also, if they have an Access Level greater then 2, then enable a command button found on page(0).
There are four possible locations and only two possible Access levels.
How would I set up such a validation process?
