VBA Walkthrough #2: Message Encoder & Decoder

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.

One thought on “VBA Walkthrough #2: Message Encoder & Decoder

  1. Hi Ben, I would just like to show my appreciation via this comment as nobody has yet made a comment on this video and simply say – you are awesome!!!

    I don’t think I’ll be able to make the VBA you run throughout this video (not anytime soon anyway) but the fact that I can now even create a click button and simply ask ‘What is you name?’ and follow it with ‘How are you doing ‘VariableName’? is a good start – so thank you.

    SB
    London

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s