Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Getting password from user

    Hi

    (Win XP SP-3, O2003 UK)

    In Excel, I'm asking a user for password through an inputbox. As he types it reveals the password - not nice . Are there a way to substitute or mask the input as asterikses??

    Alternatively does Windows have a built-in form for password inputs?

    TIA
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Star Lounger
    Join Date
    Jun 2010
    Location
    Lichfield, UK
    Posts
    55
    Thanks
    10
    Thanked 0 Times in 0 Posts
    You can create a UserForm which can be done in the VB Editor in Excel. Then create a TextBox control on that form and on its Properties set the PasswordChar property to whatever character you want it to display eg "*"

    More information on creating a UserForm and example can be found here: http://www.exceltip.com/st/Create_Us...Excel/629.html

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by njl100 View Post
    You can create a UserForm which can be done in the VB Editor in Excel.
    Thanks for the answer - appreciate it, but I'm already aware of that option. I was just hoping to achieve more or less the same with the "input box" directly, so that I don't have to go through the tedious "VB-forms" way.
    Last edited by Henrik Ryberg; 2011-02-03 at 09:19.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

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