| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
X-Y axis
Is there a way I could get the x and y axis coordinates to display in a cell as I drag the shape around with a mouse? Example ActiveSheet.Shapes.AddLine(14.25, 7.5, 143.25, 8.25).Select With ActiveSheet.Shapes.BuildFreeform(msoEditingAuto, 10.5, 378.75) .AddNodes msoSegmentLine, msoEditingAuto, 10.5, 297# .AddNodes msoSegmentLine, msoEditingAuto, 109.5, 297# .AddNodes msoSegmentLine, msoEditingAuto, 109.5, 381# .AddNodes msoSegmentLine, msoEditingAuto, 10.5, 378.75 .ConvertToShape.Select I want to be able to cross compare other shapes relative to the new position of this shape after it has been drug around by a mouse.lol I know nothing, about how to do that. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=492980 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
| Second X axis at top of chart? | Charts and Charting in Excel | |||
Linear Mode
