VBA Password Validation and Vlookup

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Dear Experts,

    I have problem and I am beginner.
    Appreciate if someone can help me ...

    I have two workbook as below.

    A) Workbook Name : Request.xls (Attached)

    Description :
    1) Where user have to download the files and fill in information before request any assistance.
    2) Form have 2 section. 1st for user to fill in and 2nd section for their bosses to approve before submit via email. (Paperless ).

    B) Workbook Name : Credentials.xls

    Description :
    1) Manage by myself (share folder on network)
    2) Cell info : Name , Dept, Div. Signature (images) and password

    i can add new name and information where possible / needed

    Scenario :

    1) User have to download the files. (on network / share folder)
    2) User have to fill in the form / request.
    3) After fill in, user have to get approval from his/her boss before submit to me via email.
    4) Under Approval Section , his/her boss need to click at cell name (dropdown list)
    5) Dropdown list information get from Cell name in workbook credentials. Any new name added, cell "name" get the latest updates.
    5) After selection of name (dropdown list) , popup UserForm that request for password to validate the user is the right person or not.
    6) IF TRUE , name, signature image from workbook credentials appear in selected cell - workbook Approval
    7) IF FALSE, error popup and clear cell - Approval Section only.
    8) After done, user have to email me the form via email.

    I attached herewith sample vba and files (sample.xls) that i found and useful but i do not know how to do it based on my situation.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!