Question : add text to Shape VBA
Answered by : jaco-de-villiers
ActiveWorksheet.Shapes(shapeIndex/Name).TextFrame2.TextRange.Text = "Hello shape"
Source : | Last Update : Fri, 24 Apr 20
Question : Add Formula to Shape Text in VBA
Answered by : jaco-de-villiers
Activesheet.Shapes(i).DrawingObject.Formula = "=A1"
Source : | Last Update : Fri, 24 Apr 20