View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default show password like *** while entering it

Tom,

You can't do this with a standard InputBox. If you really need this
capability, you need to create a user containing a TextBox control whose
PasswordChar property is set to *.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com




"tom" wrote in message
...
Hi,

I'm using this macro :
Value = Application.InputBox(Prompt:="Insert password")
If Value = "password" Then
Application.Run macro:="enter"
Else
Application.Run macro:="ignore"

While entering the password I would like the allready
inserted digits to be shown as ***

Is this possible ?

Thanks !
Tom