Change the format as data is entered

N

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
 
D

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.
 
R

Rick Rothstein \(MVP - VB\)

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

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
 
Top