Insert a shape in excel vba

Question

Hello everybody,
I am new in vba and would like to know how can i create three different rectangles in excel giving to different celles the x and y position of the origin of every shape, as well as the width and height of each rectangle.

Thank you to whoever may help.

Answer 1

Hi @Riccardo Giovinazzi

You can create rectangles with the .addshape method. For simplicity, I created a macro called test():

Cited from https://learn.microsoft.com/en-us/office/vba/api/excel.shapes.addshape

Set myDocument = Worksheets(1)   
myDocument.Shapes.AddShape msoShapeRectangle, 50, 50, 100, 200  

---------------------------------

If this is helpful please accept answer.