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
Download the Message Encryptor & Decryptor here to follow along with the video lesson.