Create arrowheads between two points to form arcs

[zecanela]

I am doing a research program and my professor asked to do this in VBA (I never used it). Let me explain:

I need to create arrowhead among certain points. Every two points are arcs for a map, and some of them are 'bothway' (I can go from point A to B and vice versa, so I would use an arrow with two heads) and others are 'oneway'.

For example:

Arc 1 (Oneway): Start point: 5 (5,10, this is the coordinate); End point:6 (20,10); I would need an arrow with one head starting from point 5 to point 6.
Arc 2 (bothway): Start point: 8 (7,22); End point:6 (20,10); I would need an arrow with two heads starting from point 8 to point 6.

Then, I have to do this for all my arcs and I already know which of them are 'oneway' or 'bothway'.

I hope it is clear, I do not know where to start because only yesterday was my first day working on vba (I was working on Matlab).

Thanks everyone,

Caio Souza.

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

There is nothing like being thrown in the deep end, is there!

What are your coordinates? Are they cell locations, points on a chart, or screen pixels from some reference, or something else?

 

[zecanela]

Hi and welcome to the MrExcel Message Board.

There is nothing like being thrown in the deep end, is there!

What are your coordinates? Are they cell locations, points on a chart, or screen pixels from some reference, or something else?

Hello RickXL, thanks.

My coordinates are to plot each point (x,y), I mean, they are points on chart. Above I gave just an example of what I have to do, indeed I have 10000 points.

I have a list with all arcs and their respective two points (for instance, from point A to point B) and I know which of them I must use arrows with two heads or with one head.

Please let me know if I was clear, I am not a good guy in English.

Thanks for helping me,

zecanela.