VBA Cheat Sheet

It has been 3 weeks of learning and I believe you have everything you need to embark on your mini projects.

Here’s a quick recap of what we have covered:

  • Setting up VBA in Excel
  • Sub Procedures vs Functions
  • Variables
  • Operators
  • If Condition
  • For Loop
  • Extracting and Writing Values to Worksheet
  • Extracting Source Code from Websites
  • Find the Last Used Row / Column
  • String Manipulation (Instr, InstrRev, Mid, Len, StrReverse)

Here’s a quick cheat sheet that I prepared. Uploading it in the *.doc format so that you can add on to it as you learn more. VBA Cheat Sheet.docx – Link

Should you want to learn more, there are countless tutorials on the internet. https://www.tutorialspoint.com/vba/index.htm is a good place to start. Happy cracking your projects! 🙂

 

 

Leave a Reply

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s