How to make straight line after edit points

G

geniusideas

Hi,

In excel after we draw line then edit the point at the center we will
get 2 different line with angle. Now I wanted to create macro when we
click this line and run this macro will make the line one horizontally
straight and another line vertically straight.
Pls help how to create this macro

http://xlsblog.com
 
B

Bernie Deitrick

Why not just add an elbow connector instead of a line?

ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 10, 10, 250, 250).Adjustments.Item(1) = 1 'or
use 0

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to draw a straight line 2
How can I edit points on a straight line in 2007 PowerPoint? 2
How to match debit and credit line item 1
how can i make a line inserted in excel be straight 2
macro to enter data into different line 2
Straight horizontal and vertical lines? 8
How to format a line between two points on a line chart? 2
How do I fit a straight line to scatter diagram chart data 1

Top