InputBox

[grahammal]

I have written a little macro that generates an InputBox so that users can enter a password. If its correct they gain access, if not it pulls up a Message Box to tell them its invalid.
Is there any code I can use that will just display "*" in the InputBox as they type in the password so that the real letters arn't displayed.

[broro183]

Hi,

Have a look at the below page & its links which I found with a quick Google ("mask password" "in input box" excel sub):

hth
Rob

[dominicb]

Good morning grahammal

OK, you have two choices here :

The easy way : Use a userform, set up a textbox and set the PasswordChar property to "*" or something.

The hard way : Use APIs to intercept the keypresses and show the "*" onscreen instead of the characters. If you take this option, you might like to take a look at Ivan F Moala's site who explains how it's done and helpfully provides some code to do so.

http://www.xcelfiles.com/API_09.html

For my money, I think if there's an easier way to do something you should take it ...

HTH

DominicB

[grahammal]

Have decided to go the UserForm way, looks & works just fine.
Thanx to all

[broro183]

thanks for the feedback :-)

DominicB, SNAP!
The excelforum.com site that I use for posting shows that we responded with effectively the same answer (my suggestion links to the same page you suggested) in the same minute - that can't happen too often!

Rob