This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros.
The lesson covers these specific areas of VBA usage:
- For…Next loop (including nested loops)
- If…ElseIf…Then Statement
- Excel functions: CHAR() / LEN() / VLOOKUP()
- VBA functions: Mod / Mid / Asc / Chr