View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Formula in comment or input message

That one is not really possible. There is no internal functionallty that does
that and macros do not operate while a cell is in edit mode.

The best options that I can give you are to use a non-proportional font like
courier new where every character is the same size and then just size your
cell accordingly. The other option would be to use a text box where you will
have greater control over the data entry.
--
HTH...

Jim Thomlinson


"Little19" wrote:

Is it possible to display the result of a formula in an input message or
comment?

I have a cell that has a limit on the number of cahracters and I would like
to show how many characters have been typed as they type.