macro for drawing

**costel_t** · 11-10-2009, 05:21 PM

i guess is simple but i just cant getting done, so please help - is obsessing me

I need draw a trapezoid by running a macro
the thing is that i need to be done it wherever i click (select) - relative - and not where is selected when i record.

I do not now if I make myself clear - wherever i click i want an trapezoid

Please help me with this.

**Andy Pope** · 11-11-2009, 05:27 AM

Put this code in a standard code module.

Select a range and run the macro

Sub InsertTrapeziod()
    With Selection
        .Parent.Shapes.AddShape msoShapeTrapezoid, .Left, .Top, .Width, .Height
    End With
End Sub

Thread: macro for drawing

Thread Tools

Display

macro for drawing

Re: macro for drawing

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions