View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Lanier Michael Lanier is offline
external usenet poster
 
Posts: 74
Default Whan a letter is entered it changes to a symbol that is the value ofa different cell

Is there a way to enter a letter in a letter in a cell and once the
Enter key is struck, the letter will change to become a symbol that is
located in another cell? More specifically:

1) I have multiple ranges where I usually enter an "x". The ranges
are A1:C10 and A20:C30.

2) There is a symbol in Z1.

When I enter the "x" in multiples places within my ranges, I want the
"x" (or any other letter that might be entered) to instantly change to
the symbol when I stike the Enter key. Is this possible? Thanks for
any help you may offer.

Michael