Tim
Here are a couple of responses given in the past to the same question.
HTH Otto

Not possible. To get a masked password, you would need to create a
UserForm
with a TextBox control. Then you can set the PasswordChar property of
the
TextBox. It would also require some simple macros to display the form
and
act on the password.
John Walkenbach

I don't think this can be done. Any macro would not have control
until
after the user had finished typing, and the prying eyes peeking. You
can

use a text box from the Control toolbox. Set its Password character
property to an asterisk. That will cause asterisks to appear in place
of
characters the user types. Then it will require some code to do stuff
with
the password. And the text box can be hidden when not needed. Or
consider
putting the textbox on a form, instead of a worksheet.
Regards from Virginia Beach,
EarlK

"Tim Childs" wrote in message
...
Hi

please can someone give me the few lines of code required to produce an
inputbox for returning text (for a password) such that each character
entered by the user is shown as an asterisk in the inputbox.

thanks

Tim