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()

- VBA functions: Mod / Mid / Asc / Chr

Download the Message Encryptor & Decryptor here to follow along with the video lesson:
excelexposure.files.wordpress.com/2012/06/message-encryptor-decryptor-vba-walkthrough-final.xlsm

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…