Double Arrow Insert with VBA

[nicotob]

Is it possible to insert a line with double arrows (an arrow at each end) using VBA. I want to insert a line similar to the Insert>Shapes>Double Arrow command in the ribbon.

On a related note, is it possible to make the end of the line a flat line. In other words, rather than a triangle or oval as the arrow head, can you have it be a short flat line that is perpendicular to the main line like this --------l ?

Thanks for the help.

This is the code I'm currently using to insert the line. I'd like it to have double arrows.

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[nicotob]

Great. Thank you.