Changing the colour and line thickness of - Microsoft Community

hello all,

i'm pretty new excel vba bear me please! want have few macros each call borderdrawline tool different colours / line types.

i've had fair go @ googling cant seem resolution. guessed @ doesn't work...

sub drawsupplyvent()

application.commandbars.executemso ("borderdrawline")
    colourindex:=3, weight:=xlthick

end sub

thanks in advance!

Office / Excel / Microsoft Office Programming / Office 2013