I was browsing for a solution to my problem and found a thread that almost does what I need but not quite.
http://www.mrexcel.com/forum/excel-questions/305014-rename-autoshape-adding-text.html
This code creates 4 hard coded trapezoids and adds the text based on 4 preset cells.
I need a...