Encrypting Project

Hello there,

The Encrypting.xlsm worksheet is a project that encrypts text, turning letters into numbers, numbers that are produced by assigning a key that provide variables to complex excel calculations.

Its purpose is to automatically "encrypt" or translate letters to words or vice-versa, according to the key used.


I need a button in the "Encryptor" sheet that is assigned with a macro that when triggered:

Will take the text, letter by letter, within a cell and paste the equivalent number for each letter into another cell.

And.. Will do the reverse process simultaneously: Take the encrpyted message from another cell, number by number (separated by a space), and paste the equivalent letter for each number into another cell.

The numbers equivalent for each letter are shown on column D from row 2 to row 28, in the "number" sheet.


I had a tough time imagining how would this project work and spent some additional effort preparing the formulas. All I need is the macro, which is quite a challenge.

If you could lend me a hand on the macro it would be great, and you'll have an encryption worksheet for your own!