View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_729_] Rick Rothstein \(MVP - VB\)[_729_] is offline
external usenet poster
 
Posts: 1
Default Change the format as data is entered

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