Not displaying keyed text in an InputBox

[u742884]

I have the following code where I prompt users for a password.

PasswordCheck = InputBox("Only Planners may export plans. Please enter password.", "Merchanise Planning", "****** *******")

Is there a way to not display the text they key in the box on the screen? If someone is looking over their shoulder, they would see the password. I would like it to show *'s like when you log into Windows.

Anyone have any ideas?

 

[hatman]

Not in an inputBox... you can do some event trapping with a Userform however... but it gets complicated screening for AlphaNumerics versus Backspace or Delete, or Enter.

 

[Norie]

With a standard inputbox you can't do this.

There are many examples on the web though that use Windows API to do this. eg

If you don't want to try that method you can create your own custom inputbox using a userform.

You can have a textbox for the password and set it's PasswordChar property to *.

 

[hatman]

Did they add PasswordChar in Excel 2003? I don't remember ever noticing it when I did this (the hard way) some 5 or 6 years ago.

 

[Norie]

Nope.

I think it's been around since 97, perhaps even earlier.

But don't quote me on that, all I know is that I can use it in 2000.

 

[lenze]

But see here
http://www.mrexcel.com/board2/viewtopic.php?t=202702&highlight=password+inputbox+hide
or
http://www.mrexcel.com/board2/viewtopic.php?t=203368&highlight=inputbox+password

lenze

 

[hatman]

Nope.

I think it's been around since 97, perhaps even earlier.

But don't quote me on that, all I know is that I can use it in 2000.

In that case I REALLY feel like an idiot (man I have gotton to use that emotion a lot in the last few days )... only inexperience at the time excuses me fro doing this the INCREDIBLY HARD WAY when the easy way was clearly available.

u742884, please ignore everything I posted in my initial reply... it appears that I answerred before doing any research.