Adding in dynamically scaling shapes to existing code

[mcmahobt]

Hello all,

I am trying to expand upon my current code (developed with much help from the forum already) to increase the tracking capability of the workbook it is applied to.

In the attached example workbook, you will see a "Before" and "After" look that I am trying to achieve.

The "Before" look generates shapes to overlay key words that match the shape's name - this is used as somewhat of a scheduling tool and works well for my purposes.

What I am now trying to achieve is a scaling rectangular shape that will fill the void in between my Start and Finish dates, that will be dynamic. I'm not sure of where to start or the best way to approach this, so help is appreciated.

Working preliminary code (also in sample workbook):

Please Login or Register  to view this content.