Conect shapes(one by one) with lines.

[MariaPap]

Hello

I don't know if it's possible but the idea is clicking a button a line to conect 2 shapes(one by one).

Can anyone helps with that?

Thanks in advance for any help

[Andy Pope]

It's possible.

here some code for your example, it will do all the connections at once but you should get the idea

Please Login or Register  to view this content.

[MariaPap]

Thank you very much sir.

I am happy that i have a reply from an Excel legend!

This works fine. My idea is that EVERY time that i click a button a new line to conect 2 shapes(1st click=conect shape A with Shape B. 2nd click=conect Shape2 with Shape3 etc...)

Is this possible? Have you some free time to help me with this?

Thank you.

[Andy Pope]

Assign button to Macro1

Please Login or Register  to view this content.

It will loop around and start again if you press the button too many times.

You probably need to keep a log of what shapes have already been connected.

And thanks for the kind words

[MariaPap]

Thank you again.

I get a

Combile error

sub or function not defined

and "ConnectShapes" part of the code getting blue in the module.

when i run the code. Do i do something wrong?

[Andy Pope]

You did not include the other code which is the function to create the line and join the shapes.

Please Login or Register  to view this content.

I did not repost that code because it did not change.

[MariaPap]

Wonderful!! Yhank you so much!!