I would like to use VBA to color a polyline along a path. I have drawn the polyline on an image, and now I want to color parts of it based on numbers in the spreadsheet. Since I have not figured out how to break the polygon into pieces that can be colored separately, I would like to drop lines on top of the polygon, each line of equal length but following the outline of the polyline.

For example, if the number in cell A1 is greater than 5, a changeEvent for the column would automatically draw the first sector of the underlying polygon and color it blue (a small line would be drawn at the top of the polyline following its path). Each cell in column A would draw a line on a different sector of the polyline, and it would be possible to color in parts of the middle part before the top or bottom parts. I would like each line to be .05 inches in length. Note: The line is vertical not horizontal, and it is crooked and not straight. Looks like a path being drawn on a map from north to south, avoiding pot holes.

Any help would be appreciated. Just knowing how to create a predifined path of lines in VBA would be helpful.