How can i enter data in excel in such a way that as I enter the format will
be changed.
For eg: when i enter 12345 the format should change to *****. This should
happen as I enter data and not after I enter data and hit enter

Two ways:

1. use a macro. See OnKey in Excel VBA help

2. use a userform
--
Gary''s Student - gsnu200793


"Niju David" wrote:

> How can i enter data in excel in such a way that as I enter the format will
> be changed.
> For eg: when i enter 12345 the format should change to *****. This should
> happen as I enter data and not after I enter data and hit enter

Could you please elaborate on this

"Gary''s Student" wrote:

> Two ways:
>
> 1. use a macro. See OnKey in Excel VBA help
>
> 2. use a userform
> --
> Gary''s Student - gsnu200793
>
>
> "Niju David" wrote:
>
> > How can i enter data in excel in such a way that as I enter the format will
> > be changed.
> > For eg: when i enter 12345 the format should change to *****. This should
> > happen as I enter data and not after I enter data and hit enter

Excel doesn't support anything like this when you're entering data into a cell.

But you could design a userform with a textbox and use the passwordchar property
to hide the value as it's being entered.

Niju David wrote:
>
> How can i enter data in excel in such a way that as I enter the format will
> be changed.
> For eg: when i enter 12345 the format should change to *****. This should
> happen as I enter data and not after I enter data and hit enter

--

Dave Peterson

> Excel doesn't support anything like this when you're entering data into a
> cell.

Just to add to Dave's statement...

Even if you could set up a format to mask the display in the cell, the true
value would always be displayed in the formula bar... that is just the way
Excel works. Accepting passwords (what I think you [the OP] are asking for)
is not something a worksheet was designed to do. The suggestion to use a
UserForm is the way to go.

Rick