Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    *** in password field (2003)

    Loungers, I hope someone can help. I've prepared a small text box too enter a password that will open selected worksheets. As it is now when you enter the password there is no text visible - I wanted to be able to show ****'s when entering the password text.

    Any suggestions?

    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *** in password field (2003)

    Is this a textbox on a userform? If so, you could use the keydown event to grab and store each character and replace it with an asterisk. You will also have to handle special keys like backspace in your code.
    Legare Coleman

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: *** in password field (2003)

    The TextBox from the Controls ToolBox has a PasswordChar property which can be set to an asterisk (or an alternative). As text is input the display converts each character to an asterisk or whatever.

    The TextBox for UserForms is similar.

    Andrew C

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: *** in password field (2003)

    Legare - thanks for the quick reply. This is a VBA form and relates to the <post#=361633>post 361633</post#> re: <post#=361248>post 361248</post#> from jeffersdj by Servando.
    The example provided by Servando works well, any thoughts or improvements on his code?

    Regards <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *** in password field (2003)

    Verada
    As Andrew said...

  6. #6
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: *** in password field (2003)

    Sevando - Thank you for all you assistance - all works well (other than the problem in my recent post - any thoughts?)

    Regards <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

Posting Permissions

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