I am a little unclear where "as I told you already" comes from but none the
less. The input box does NOT have a facility to display a password character.
The only way around it is with a TextBox. You get get this from a form or you
can embed one in your sheet from the Control Toolbox. If neither of those
will work for you then I guess you are stuck with what you have...

As a complete aside, avoid using phrases like "as I told you already". They
come off as a little offensive. Instead of assuming that we did not read your
question closely enough you are better off to assume that perhaps you were
not entirely clear in your request.
--
HTH...

Jim Thomlinson


"praveen_khm" wrote:


Thanks both....

However, I cannot add a text form box now. The only option is to change
this code. Ok, is it possible that I can input a textbox using the code
and not by going to userform and entering it? The reason is, as I told
you already, I cannot add a box. If there is any way that I can enter
the textbox and a password using the code, please let me know. If not,
thats ok, I ll try manage.....thanx again.......


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=534640