Elbow Connector - VBA Help to change format

[bposaner]

I'm trying to change the colour and thickness of my elbow connector via a macro, but cant find how to do it. Tried to record it, but nothing is recorded...DOH!
Searching is not giving me much help, can anybody help!!!

All I want to do is be able to change the thickness/colour or the elbow line depending on a number. Thats it! So how can i change the colour/width is a macro?

Cheers for the help!
bposaner

 

[RoryA]

For example:

    With ActiveSheet.Shapes("Elbow Connector 1")
        With .Line
            .Visible = msoTrue
            .ForeColor.RGB = RGB(255, 0, 0) ' Red
            .Visible = msoTrue
            .Weight = 3 ' 3pt line weight
        End With
    End With

 

[bposaner]

Rorya
Thanks for the quick response!
Cheers, knew it would be a simple as this, but just could not find an example!!