Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shape names
I am creating several shapes with the code shown below. It works fine.
The problem is that I do not know how to retrieve the shape's name (in the macro) when one shape is selected. Any ideas? The following is part of the code that creates the shapes. " ActiveSheet.Shapes.AddShape(msoShapeRectangle, MyLeft, MyTop, _ MyHoursToGo * MyScale, MyHeight).Select Selection.ShapeRange.Fill.ForeColor.RGB = RGB(204, 255, 255) Selection.ShapeRange.Name = MyName ' Selection.OnAction = "Describe" Selection.Characters.Text = MyJob & Chr(10) & MyPart & Chr(10) & MyOperation With Selection.Characters.Font .Name = "Arial" .Size = MyFontSize End With " Note that the "OnAction" is commented out because I cannot retrieve the individuals shape's name. Your help is appreciated. Thank you. Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shape names
Don,
Not really sure what the problem is. You don't need the n ame to set the OnAction, it works fine without it. Do you not know the shape name? It is in MyName. In the macro, you can get the shape name with Application.Caller Does any of this help? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Don Rouse" wrote in message ... I am creating several shapes with the code shown below. It works fine. The problem is that I do not know how to retrieve the shape's name (in the macro) when one shape is selected. Any ideas? The following is part of the code that creates the shapes. " ActiveSheet.Shapes.AddShape(msoShapeRectangle, MyLeft, MyTop, _ MyHoursToGo * MyScale, MyHeight).Select Selection.ShapeRange.Fill.ForeColor.RGB = RGB(204, 255, 255) Selection.ShapeRange.Name = MyName ' Selection.OnAction = "Describe" Selection.Characters.Text = MyJob & Chr(10) & MyPart & Chr(10) & MyOperation With Selection.Characters.Font .Name = "Arial" .Size = MyFontSize End With " Note that the "OnAction" is commented out because I cannot retrieve the individuals shape's name. Your help is appreciated. Thank you. Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shape coordinates | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Inserting into a shape | Excel Discussion (Misc queries) | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |