Masking the character in input box

B

Bakar

Hi Masters
I have an input box for password
When i am entering the pw its showing the character ex "1234"
I want to mask the "1234" to "****"
Here is the macro
Const pWord As String = "1234"


Sub UnHide()
Sheet1.Range("b3").Select
Selection.ClearContents
If InputBox("Please enter password to open DATA BASE!", "SQ Sweate
SMV", _
"Enter Password") = pWord Then
Sheet5.Visible = xlSheetVisible
Sheet5.Activate

End If

End Sub
Please help

Baka
 
C

Cimjet

Hi Masters

I have an input box for password

When i am entering the pw its showing the character ex "1234"

I want to mask the "1234" to "****"

Here is the macro

Const pWord As String = "1234"





Sub UnHide()

Sheet1.Range("b3").Select

Selection.ClearContents

If InputBox("Please enter password to open DATA BASE!", "SQ Sweater

SMV", _

"Enter Password") = pWord Then

Sheet5.Visible = xlSheetVisible

Sheet5.Activate



End If



End Sub

Please help



Bakar

Hi
I don't think you can do it with an Inputbox.
I use a Textbox on a userform and in the Properties for the Textbox, you have "Password Char", you can type an asterisk or anything else you like too see.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top