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?)
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
No comments:
Post a Comment