View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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