A shape only knows the click event so resizing a shape won't activate any code.

The only workaround I can think of is putting an Active-X label on the worksheet so you can use the mouseover- event to recalculate the dimensions.

You could place that label in a convenient place, remove the caption and set backstyle to transparent so it's invisible but present.