My question is about freeform shapes in Excel 2007.
When I create a freeform shape with a mouse I can link it to a cell so that it displays whatever text is entered in that cell. I can do that by simply selecting the shape, and typing e.g. = A1 in the formula window.
However, I have not been able to do that in VBA code, i.e. programmatically.
Moreover, if I create a freeform shape programmatically in VBA, then I can not link it to a cell.
What properties of a shape need to be accessed to link it to a cell?
When I create a freeform shape with a mouse I can link it to a cell so that it displays whatever text is entered in that cell. I can do that by simply selecting the shape, and typing e.g. = A1 in the formula window.
However, I have not been able to do that in VBA code, i.e. programmatically.
Moreover, if I create a freeform shape programmatically in VBA, then I can not link it to a cell.
What properties of a shape need to be accessed to link it to a cell?
