Excel Hack 38: Create dynamic labels for shapes or cells in Excel
You might be working with maps or shapes in Excel that you need to have specific descriptors depending on a particular event. The macro below shows how to set this up in an Excel workbook. First, create your shape/map. Next, create a text box that will operate as a label for your shape/map, and give