IF Then Printf

[leveex]

I need some kind of formula for excel that will, as I am typing some letters will write another letters that I have previously defined. For example I have defined whole alphabet (“A" isn't an "A" but "TREE" "B" isn't "B" than "SUN" C=DOG so if I write "BAC" it will print SUN TREE DOG
Thanks in advance

[Leith Ross]

Hello leevex,

Welcome to the Forum!

There isn't a formula to do what you want. You would have to use a VBA macro. The restriction with this your words could not be displayed until all the letters were entered. This assumes that you are using only single letters to represent the words. Would this this be an acceptable solution?

[leveex]

Hello leevex,

Welcome to the Forum!

There isn't a formula to do what you want. You would have to use a VBA macro. The restriction with this your words could not be displayed until all the letters were entered. This assumes that you are using only single letters to represent the words. Would this this be an acceptable solution?

That's exactly what I need. when I write whole word it display "code"
Could You please help me with that macro?
Thanks in advance

[Leith Ross]

Hello leveex,

I can help with the code. I need to answer some other posts and then I will start writing the macro.

[Leith Ross]

Hello leevex,

This is a Worksheet Event macro. It will convert the letters into a phrase based on the individual characters that were typed in. None matching characters are ignored. If there are no matches then cell will be empty.

The macro uses two named ranges Letters and Words. These are used to look up the word associated with a letter. You will need to create these ranges before running the macro. If you decide to name the ranges differently then be sure to change s the names in bold below to match.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro

1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S

[leveex]

Thanks a lot

[leveex]

I managed, thanks for the effort and the script.