Input box question

[viper]

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.

 

[Legacy 98055]

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

 

[viper]

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