Dears,
i am adding shape thru my coding below is sample, but while declaring object use of "S" thing confuses me always.
i.e. whether to use shape/shapes how could i identify this.
Regards,
i am adding shape thru my coding below is sample, but while declaring object use of "S" thing confuses me always.
i.e. whether to use shape/shapes how could i identify this.
Code:
Sub test()
Dim sh As Shape
Set sh = ThisWorkbook.ActiveSheet.Shapes.AddShape(msoShapePentagon, 5, 5, 5, 5)
End Sub
Sub test2()
Dim shp As Shape, shps As Shapes
Set shp = ThisWorkbook.ActiveSheet.shps.AddShape(msoShapePentagon, 5, 5, 5, 5)
End Sub
Regards,