Excel VBA Login Security Enhancement
Budget: ₹12,500 – ₹37,500 INR
Login Tracker Functionality Overview
- Security Question Validation (wsQ1andQ2)
- Ensures selected security questions (from cells D1 and F1) are not identical.
- Displays a warning message if both questions are the same.
- Password Change via Checkbox (CheckBox1_Click)
- Prompts user to confirm intent to change password.
- Validates username input and searches for it in column B.
- Asks for answers to two security questions stored in columns D and F.
- If answers match, allows user to set a new password with confirmation.
- Prevents reuse of old password and mismatched confirmation.
- Updates password and logs timestamp in column H.
- Re-protects the sheet after operation.
- Login Validation (CommandButton1_Click)
- Checks for empty username or password fields.
- Validates credentials against stored data in columns B and C.
- If password is expired (column I = "Yes"), prompts for new password.
- Prevents reuse of old password and mismatched confirmation.
- Updates password and timestamp if changed.
- If login is successful, greets user and opens next form (UserForm3).
- Displays error messages for incorrect credentials or missing records.
- Form Navigation
- CommandButton2_Click: Hides UserForm1.
- CommandButton3_Click: Opens UserForm2.
- Security Question Validation (wsQ1andQ2)
- Ensures selected security questions (from cells D1 and F1) are not identical.
- Displays a warning message if both questions are the same.
- Password Change via Checkbox (CheckBox1_Click)
- Prompts user to confirm intent to change password.
- Validates username input and searches for it in column B.
- Asks for answers to two security questions stored in columns D and F.
- If answers match, allows user to set a new password with confirmation.
- Prevents reuse of old password and mismatched confirmation.
- Updates password and logs timestamp in column H.
- Re-protects the sheet after operation.
- Login Validation (CommandButton1_Click)
- Checks for empty username or password fields.
- Validates credentials against stored data in columns B and C.
- If password is expired (column I = "Yes"), prompts for new password.
- Prevents reuse of old password and mismatched confirmation.
- Updates password and timestamp if changed.
- If login is successful, greets user and opens next form (UserForm3).
- Displays error messages for incorrect credentials or missing records.
- Form Navigation
- CommandButton2_Click: Hides UserForm1.
- CommandButton3_Click: Opens UserForm2.
Related categories:
Data Entry
Excel
Software Development
Excel VBA
Excel Macros
Security
Data Management
Data Protection