jignesh142
02-05-2013, 01:27 AM
i want to make custom flowchart software in the excel and i succeed to make shapes and arrows etc with VBA
now the problem comes when i want to add the elbow arrow between the two shapes which are not aligned.
i can do this with the Activesheets.shapes.addconnector(msoconnectorebow,x1,y1,x2,y2).select
the main thing here is that i don't want to specify the value of x1.y1.x2.y2 in the function but i want to select the two shapes and to draw the arrow dynamically
can anybody help me to activate this command only with vba?
now the problem comes when i want to add the elbow arrow between the two shapes which are not aligned.
i can do this with the Activesheets.shapes.addconnector(msoconnectorebow,x1,y1,x2,y2).select
the main thing here is that i don't want to specify the value of x1.y1.x2.y2 in the function but i want to select the two shapes and to draw the arrow dynamically
can anybody help me to activate this command only with vba?