change the characters entered in cell as a Password charactes

Hi,

Is there any possiblity to change the text entered in a cell to be displayed as a Password field. means all characters entered would be replaced by"*".
Thanks
Raj

format=>Cells=>Number Tab, choose custom

"*";"*";"*";"*"

--
Regards,
Tom Ogilvy


"rajendran" <rajendran.1zo5im_1133957402.9266@excelforum-nospam.com> wrote
in message news:rajendran.1zo5im_1133957402.9266@excelforum-nospam.com...
>
> Hi,
>
> Is there any possiblity to change the text entered in a cell to be
> displayed as a Password field. means all characters entered would be
> replaced by"*".
> Thanks
> Raj
>
>
> --
> rajendran
> ------------------------------------------------------------------------
> rajendran's Profile:
http://www.excelforum.com/member.php...o&userid=29252
> View this thread: http://www.excelforum.com/showthread...hreadid=491419
>

Just be aware that if the cell is selected, the entry is visible in the
formula bar.

--
Regards,
Tom Ogilvy

"rajendran" <rajendran.1zo5im_1133957402.9266@excelforum-nospam.com> wrote
in message news:rajendran.1zo5im_1133957402.9266@excelforum-nospam.com...
>
> Hi,
>
> Is there any possiblity to change the text entered in a cell to be
> displayed as a Password field. means all characters entered would be
> replaced by"*".
> Thanks
> Raj
>
>
> --
> rajendran
> ------------------------------------------------------------------------
> rajendran's Profile:
http://www.excelforum.com/member.php...o&userid=29252
> View this thread: http://www.excelforum.com/showthread...hreadid=491419
>

Tom,

Its displaying only one "*" for the whole word. cant we change each character to "*" and get it vb script code.

Actually i am having a username and password (for my server )to be typed in a cell. cant we make the same appearence as standard password field.

Regards
Raj

You could use the change event

Right click on the sheet tab and select view code. then put in code like
this:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrHandler
If Target.Address = "$B$9" Then
Application.EnableEvents = False
sStr = Chr(34) & Application.Rept( _
"*", Len(Target.Value)) & Chr(34)
Target.NumberFormat = sStr & ";" & sStr & ";" & _
sStr & ";" & sStr
End If
ErrHandler:
Application.EnableEvents = True
End Sub

--
Regards,
Tom Ogilvy


"rajendran" <rajendran.1zo7lo_1133960120.4296@excelforum-nospam.com> wrote
in message news:rajendran.1zo7lo_1133960120.4296@excelforum-nospam.com...
>
> Tom,
>
> Its displaying only one "*" for the whole word. cant we change each
> character to "*" and get it vb script code.
>
> Actually i am having a username and password (for my server )to be
> typed in a cell. cant we make the same appearence as standard password
> field.
>
> Regards
> Raj
>
>
> --
> rajendran
> ------------------------------------------------------------------------
> rajendran's Profile:
http://www.excelforum.com/member.php...o&userid=29252
> View this thread: http://www.excelforum.com/showthread...hreadid=491419
>