View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Vic Eldridge[_3_] Vic Eldridge[_3_] is offline
external usenet poster
 
Posts: 112
Default How do I refer to a freeform name and number on a chart using

Hi Raas,

When creating any object (such as a shape object) , you can assign the
object to an "object variable" , whose scope and lifetime are at your
complete control.

eg

Sub AddFreeformShape()

Dim FFB As FreeformBuilder
Dim Shp As Shape

Set FFB =
ActiveSheet.ChartObjects(1).Chart.Shapes.BuildFree form(msoEditingCorner, 360,
200)
With FFB
.AddNodes msoSegmentCurve, msoEditingCorner, 380, 230, 400, 250,
450, 300
.AddNodes msoSegmentCurve, msoEditingAuto, 480, 200
.AddNodes msoSegmentLine, msoEditingAuto, 480, 400
.AddNodes msoSegmentLine, msoEditingAuto, 360, 200
Set Shp = .ConvertToShape
End With

MsgBox Shp.Name

End Sub




"Raas" wrote:

Thank you, but I already knew this part. I want to be able to retrieve the
freeform name and number from the system so I can refer to it. Each new
polygon I put on this chart gets a new freeform number assigned
automatically, and I need to retrieve this number out of the name.
--
Raas


"Vic Eldridge" wrote:

ActiveChart.Shapes("Freeform 1").Fill.ForeColor.RGB = vbRed

"Raas" wrote:


--
Raas