Change the format as data is entered

[Niju David]

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

 

[Gary''s Student]

Two ways:

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

2. use a userform

 

[Niju David]

Could you please elaborate on this

Two ways:

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

2. use a userform

 

[Dave Peterson]

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.

 

[Rick Rothstein \(MVP - VB\)]

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