This video has a lot of VBA discussion. Some is pretty simple and some is more complicated with strategies to make the the calculations more quick. You can find the associated file at www.edbodmer.com. Courses that address VBA and other issues are at www.financeenergyinstitute.com.