Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
MS Access .Control objects have a .Tag property where you can store whatever you
need. Does anybody know of something analogous in a .Chart or .Shape? I need to store a range address like "$R05$C13:$R45$C22". -- PeteCresswell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
I just posted something in your earlier thread.
Peter T "(PeteCresswell)" wrote in message ... MS Access .Control objects have a .Tag property where you can store whatever you need. Does anybody know of something analogous in a .Chart or .Shape? I need to store a range address like "$R05$C13:$R45$C22". -- PeteCresswell |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
Hi Pete -
I think PowerPoint shapes have this, but Excel shapes do not. However, you could add an invisible textbox to a chart: activechart.Shapes.AddTextbox(msoTextOrientationHo rizontal,0,0,100,15).Name = "MyTag" activechart.Shapes("MyTag").TextFrame.Characters.T ext="$R05$C13:$R45$C22" activechart.Shapes("MyTag").Visible=false ?activechart.Shapes("MyTag").TextFrame.Characters. Text $R05$C13:$R45$C22 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "(PeteCresswell)" wrote in message ... MS Access .Control objects have a .Tag property where you can store whatever you need. Does anybody know of something analogous in a .Chart or .Shape? I need to store a range address like "$R05$C13:$R45$C22". -- PeteCresswell |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
Per Jon Peltier:
I think PowerPoint shapes have this, but Excel shapes do not. However, you could add an invisible textbox to a chart: activechart.Shapes.AddTextbox(msoTextOrientationH orizontal,0,0,100,15).Name = "MyTag" activechart.Shapes("MyTag").TextFrame.Characters. Text="$R05$C13:$R45$C22" activechart.Shapes("MyTag").Visible=false ?activechart.Shapes("MyTag").TextFrame.Characters .Text $R05$C13:$R45$C22 Thanks. That will definitely do it. I'll hold off on merging the chart creation/positioning processes and give that a shot. -- PeteCresswell |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
Actually, to me it sounded like a fine idea to create and position the chart
all at once. In fact, using mySheet.ChartObjects.Add() does both at once; check the documentation or look for it he http://peltiertech.com/Excel/ChartsH...kChartVBA.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "(PeteCresswell)" wrote in message ... Per Jon Peltier: I think PowerPoint shapes have this, but Excel shapes do not. However, you could add an invisible textbox to a chart: activechart.Shapes.AddTextbox(msoTextOrientation Horizontal,0,0,100,15).Name = "MyTag" activechart.Shapes("MyTag").TextFrame.Characters .Text="$R05$C13:$R45$C22" activechart.Shapes("MyTag").Visible=false ?activechart.Shapes("MyTag").TextFrame.Character s.Text $R05$C13:$R45$C22 Thanks. That will definitely do it. I'll hold off on merging the chart creation/positioning processes and give that a shot. -- PeteCresswell |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
Per Jon Peltier:
Actually, to me it sounded like a fine idea to create and position the chart all at once. In fact, using mySheet.ChartObjects.Add() does both at once; check the documentation or look for it he http://peltiertech.com/Excel/ChartsH...kChartVBA.html I thought so too... but the invisible text box solution is working a-ok for me and I'm going to stick with what I've got until the user sees some output that they like. By then, I'll have some elapsed time logging in the process and when I go back to optimize that'll be a good time to make the big change. That way I'm covered in case the big change takes too long and the user needs the output ASAP..... -- PeteCresswell |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
Well, yeah, you don't want to break something that's working fine. That's
why I was up till midnight, because I made a couple improvements to a working and near production project, but also incorporated a couple glitches. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "(PeteCresswell)" wrote in message ... Per Jon Peltier: Actually, to me it sounded like a fine idea to create and position the chart all at once. In fact, using mySheet.ChartObjects.Add() does both at once; check the documentation or look for it he http://peltiertech.com/Excel/ChartsH...kChartVBA.html I thought so too... but the invisible text box solution is working a-ok for me and I'm going to stick with what I've got until the user sees some output that they like. By then, I'll have some elapsed time logging in the process and when I go back to optimize that'll be a good time to make the big change. That way I'm covered in case the big change takes too long and the user needs the output ASAP..... -- PeteCresswell |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart or Shape Object: A Place To Stash A Few Bytes?
Declare a new class module and add whatever bytes you want to stash,
along with the chart object. (PeteCresswell) \/\/|20+3: MS Access .Control objects have a .Tag property where you can store whatever you need. Does anybody know of something analogous in a .Chart or .Shape? I need to store a range address like "$R05$C13:$R45$C22". -- PeteCresswell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Place shape/clipart over radio button | Excel Discussion (Misc queries) | |||
Chart wizard will not place (as object in) graph in same sheet | Excel Worksheet Functions | |||
shape object on a userform? | Excel Programming | |||
How to tell wich object/shape was clicked | Excel Programming | |||
XL2000: Shape object events | Excel Programming |