+ Reply to Thread
Results 1 to 7 of 7

Inpubox password

  1. #1
    Registered User
    Join Date
    03-11-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    59

    Inpubox password

    Hi, Everyone!
    I just need help.

    So what should happen is that if the save button was clicked it will ask for a password to be entered once entered and matches then all of the textboxes details will be added to Log in

    Password should be on Master file sheet column AZ
    example:
    If Textbox1.value matches with Password then data will be saved
    Last edited by serenitylai; 03-30-2017 at 07:52 PM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,162

    Re: Inpubox password

    Hi serenitylai

    Does each person have there own password in Column AZ corresponding to their name.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,162

    Re: Inpubox password

    Any reason why you are not using a combobox with dropdown for employee no which will populate the necessary textboxes with vlookup vba

  4. #4
    Registered User
    Join Date
    03-11-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    59

    Re: Inpubox password

    Quote Originally Posted by sintek View Post
    Hi serenitylai

    Does each person have there own password in Column AZ corresponding to their name.
    hello!!! Yes.

  5. #5
    Registered User
    Join Date
    03-11-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    59

    Re: Inpubox password

    Quote Originally Posted by sintek View Post
    Any reason why you are not using a combobox with dropdown for employee no which will populate the necessary textboxes with vlookup vba
    they have to type their employee no. in order to populate everything else. There's like 400+ employees.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,162

    Re: Inpubox password

    Hi Serenitylai

    I was working on something and strange enough had to open another thread to solve a silly silly error...Thanks to Norie - i got it figured out.
    Put this code in a Module
    Please Login or Register  to view this content.
    and in your Main code just before the line where you want the check, add this code
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-11-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    59

    Re: Inpubox password

    Thank you, Sintek! Y

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Storing numbers through inpubox
    By maroon1 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-13-2016, 09:41 PM
  2. Storing numbers through inpubox
    By maroon1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2016, 12:00 AM
  3. Replies: 0
    Last Post: 04-26-2006, 10:25 PM
  4. Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  5. Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Replies: 0
    Last Post: 06-23-2005, 07:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1