Create arrowheads between two points to form arcs

zecanela

New Member
Joined
Jun 15, 2015
Messages
2
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.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

RickXL

MrExcel MVP
Joined
Sep 9, 2013
Messages
4,325
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

New Member
Joined
Jun 15, 2015
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,606
Messages
5,597,134
Members
414,128
Latest member
Jorglo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top