How to make straight line after edit points

  • Thread starter Thread starter geniusideas
  • Start date Start date
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
 
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

Scatter Plot Question - adding straight lines 0
How to draw a straight line 2
VBA Multiple Line handling with Split() 1
Straight horizontal and vertical lines? 8
how do i get straight lines in Power Point 2007 3
Center Text on Point 1
Restore ability to draw straight lines with freeform by holding sh 3
how can i make a line inserted in excel be straight 2

Back
Top