Generating form analysis is a tricky task that can only really be done using Excel VBA. We need to resist the tempation to 'jump straight in', and take the time to take step a back, view the whole task, and create a plan.  Since, if the concepts are not clear in our own head, the technical stuff is virtually impossible! 

In this video, we use 'pseudo-code' to draw up a blueprint for this sophisticated VBA routine.  Make sure you download the file and work along with Chris.  Next - the process of translating these instructions from human language to Excel VBA.

Tools And Techniques

- planning and conceptualising a VBA routine
- making annotations in the VBA editor