# Create arrowheads between two points to form arcs

#### zecanela

##### New Member
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.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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?

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.

Replies
5
Views
186
Replies
4
Views
650
Replies
3
Views
689
Replies
0
Views
671
Replies
1
Views
1K

### Forum statistics

Threads
1,221,425
Messages
6,159,831
Members
451,592
Latest member
Mrformulaheadache

### 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

### 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