Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Input box question

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is the code used to display asterisks when the user keys in the password?

    My code is below, how would I change it so the user will see asterisks?

    Dim Pw As String
    Cells.EntireColumn.Hidden = True
    Pw = InputBox("Enter Password")
    If Pw = "Camaro" Then Cells.EntireColumn.Hidden = False: End
    Sheet2.Activate
    If Pw <> "Camaro" Then
    MsgBox ("Sorry, incorrect password, Good Bye!")
    Sheet1.Activate
    End If

    Thanks in advance.

    I appreciate the help from everyone at Mr. Excel.

    viper

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there
    As far as I know, you cannot do this in the input box...
    I could be wrong though..
    If you will settle for a textbox on a userform, then you're in business...
    Tom

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Tom,

    I changed it to use a text box and it works as I want. I just thought changing to a text box would involve more work than it did.

    Thanks again,
    viper
    I appreciate the help from everyone at Mr. Excel.

    viper

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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