Obtain the data source Axis Title

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gilles P (FR) - 06 Feb 2008 15:47 GMT

Hello,

With standard interactive ExcelGraph, I create a title of axis wich is the
cell value of a worksheet
by a formula "=Sheet1!R1C1"
To obtain an axe title linked with the cell value

How with VBA can i read this formula ?
the property "Axes(xlValue, xlPrimary).AxisTitle.Text " give the value of
R1C1 and not the formula ?

Thanks

Gilles PROVOST (FR)

Reply to this Message

Dave D-C - 06 Feb 2008 17:01 GMT

I haven't tried this, but how about
Dim s1$, sFormula$
s1 = Axes(xlValue, xlPrimary).AxisTitle.Text
sFormula = Range(s1).Formula
Dave D-C

>Hello,
>
[quoted text clipped - 10 lines]
>
>Gilles PROVOST (FR)

Reply to this Message

Gilles P (FR) - 06 Feb 2008 17:22 GMT

Sorry but,
That's doesn't work

S1 return the value (and not the formula)
And so Range(S1).formula gives an error by "property method error"

regards,

Gilles P (FR)

> I haven't tried this, but how about
> Dim s1$, sFormula$
[quoted text clipped - 16 lines]
> >
> >Gilles PROVOST (FR)

Reply to this Message

Andy Pope - 07 Feb 2008 15:45 GMT

Hi,

Try this with an active chart,

msgbox ExecuteExcel4Macro("GET.FORMULA(""Title"")")

Apparently does not work in xl2007.

Cheers
Andy

> Hello,
>
[quoted text clipped - 10 lines]
>
> Gilles PROVOST (FR)

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message