Showing object size in a cell

[ISARTC3]

Is there any way to show the size of an object in a cell.
Im trying to find a way to put dimensions arrows to an object that as I stretch the arrow longer the dimensions will grow in real time. Similar to what a cad or drawing program would do.

[Leith Ross]

Hello ISARTC3,

Since Shapes don't expose any events through VBA, you can't dynamically show the size of the object. You can only get the size statically by first selecting it, and then checking the properties relating to size.

Sincerely,
Leith Ross