Perhaps the link below will help

http://www.cpearson.com/excel/DebuggingVBA.aspx