i need to create a macro to draw a rectangle by two point , the first point is : x = (max margin left of the sheet), y=(pick by mouse) and the second point is : x = (max margin right of the sheet), y=(pick by mouse).
do you have any idea ?
thank you
Marco
Michele Salvagno said:i need to create a macro to draw a rectangle by two point
Here's a VBA example project: Create Shape using VBA. You can download the project from that page and examine the code.
Regards, Jon Summers LA Solutions