Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default FreeFormBuilder Bug?

I am trying to place lines on a chart (contour lines in a colour
plot).
Below is a bit of sample code which shows the issue (it needs a chart
to exist and be selected to run). For some reason Excel seems to
scramble the node coordinates. (but only sometimes, hence the rather
specific values)

Sub ctest()
Dim ch As Chart
Set ch = ActiveChart
Dim sh As FreeformBuilder, p As Shape
Set sh = ch.Shapes.BuildFreeform(msoEditingAuto, 417.834413382186,
112.243677843221)
sh.AddNodes msoSegmentLine, msoEditingAuto, 408.377347163292,
119.024547401276
Set p = sh.ConvertToShape
MsgBox "x = " & p.Nodes(1).Points(1, 1) & " Y = " & p.Nodes(1).Points
(1, 2) & vbCr & "x = " & p.Nodes(2).Points(1, 1) & " Y = " & p.Nodes
(2).Points(1, 2)
End Sub
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
freeformbuilder boyze Charts and Charting in Excel 2 April 3rd 07 02:46 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"