+ Reply to Thread
Results 1 to 5 of 5

How to protect passwords with asterisks

  1. #1
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    How to protect passwords with asterisks

    So I've been trying for quite some time to get a input box to come up and allow for protected passwords to be entered.

    I have my code working with input boxes, and I've gotten a user form that allows for the passwords to be displayed as asterisk. How do I call my user form instead of an input box, or is there a lot more tweaking that needs to be done?

    Thanks in advance

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: How to protect passwords with asterisks

    TextBox have property PasswordChar, so you just choose symbol to be displayed while typing password in this TextBox. Perhaps much more easy than using InputBox.
    Now you work with InputBox, so you read user input like:
    Please Login or Register  to view this content.
    If you want to use Textbox so make UserForm with textbox and use Textbox.Text to compare user input with defined password.
    To show UserForm:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: How to protect passwords with asterisks

    Thanks I'll give it a shot.

    So I put it as

    Please Login or Register  to view this content.
    And use the .show function to call it?

  4. #4
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: How to protect passwords with asterisks

    Emm, your TextBox is on the UserForm, so you need use
    Please Login or Register  to view this content.
    to call your UserForm.

  5. #5
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: How to protect passwords with asterisks

    Yeah I can get it to display, but I can't get it to interact with the rest of my code.

    Do I need to move all of my code into the user form itself, or can I interact with a module in some way.

    Really hoping I don't need to make a separate user form every time I need a new password.

+ 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. protect worksheet with multiple passwords
    By andyc209 in forum Excel General
    Replies: 2
    Last Post: 02-18-2014, 12:06 AM
  2. Password Protect - Multiple Passwords
    By aspears in forum Excel General
    Replies: 0
    Last Post: 12-08-2008, 01:12 PM
  3. [SOLVED] Passwords Disappear in OpenOffice (Protect Worksheet, and Protect Workbook)
    By msnews.microsoft.com in forum Excel General
    Replies: 6
    Last Post: 12-27-2005, 04:20 AM
  4. How to protect different cells by diff. passwords?
    By Mlavi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. [SOLVED] How to protect different cells by diff. passwords?
    By Paul Moles in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 05:05 PM
  6. How to protect different cells by diff. passwords?
    By Paul Moles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  7. How to protect different cells by diff. passwords?
    By Mlavi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  8. How to protect different cells by diff. passwords?
    By Mlavi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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