Excel VBA Tutorial | Monitor Website

This tutorial was recorded focusing mainly on debugging with little focus on the common factors of the basic language.  Absolute Beginners may find this tutorial a bit challenging to follow.  If you are able to complete the program show in the tutorial, you will have a fully functional macro add-in within Excel that will allow you to check the status of Demonoids' registrations at the push of a button. (You did assign a hotkey, didn't you?)

Subscribe to my videos on YouTube
Browse Excel VBA Books

In this video you will see:

• A Macro Recorded
• Data Imported from a Website
• Option Explicit
• Select Case Blocks
• Creation and Use of a Function
• Passing Variables to a Function
• Using Data Returned from a Function
• Multiple Common Mistakes Made and Corrected
• Error Handling Code
• Saving as an Add-in
• Bypassing Program Alerts (ie. Are you sure want to delete this file?) 
• Functions: Instr, Lcase, Msgbox, Instr