So, we've managed to automate the process of creating a heat map, including formatting and conversion to values.  Cool!  This gives us some kind of 'click-of-a-button' functionality.  At the same time, we are feeling the limitations of our implementation: for example, the heat map allows only 2 variables to be explored.  What if we wanted to create a heat map for each team in the league, for example?  To do so would be time-intensive, even with our VBA-based solution.

To move forward requires a deeper dive into VBA coding.  We start this process this week, with the aim of generating multiple (20?) heat maps at the click of a button.  Be aware, however, that learning these techniques takes time - you may not have a new analysis at the end of each session!  I hope you're in for the long haul, I guarantee it will be worth it in the end ...

With that in mind, we set about exploring what is required.  We first look at calling multiple macros from a single button.  This technique permits a 'modular' (like IKEA furniture!) approach that can be so powerful in VBA coding.  Watch along with the video and try it out for yourself.

Then we look at entering a value into a cell to determine where the heat map appears in the spreadsheet.  This involves some mind-bending VBA code - make sure you create it and test it yourself.  And don't forget the homework challenge at the end of the session!

Topics And Techniques

- Assign A Macro To A Button
- Call One Macro From Another
- Range(Range(Reference).Value).Value Technique
- Planning A VBA Macro
- Stepping Through VBA Code