Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Retrieving linked label formula with VBA
Dear group,
I linked datalabels of a chart with cells (by selecting a single label, typing "=", clicking the cell to link with and then enter). Now I want to get the label's formula with VBA, but I only get the value with objPoint.DataLabel.Text. I am missing something like objPoint.DataLabel.Formula. Currently I use XL 2003. Any good ideas? Thanks in advance, Holger. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Retrieving linked label formula with VBA
hi, Holger !
I linked datalabels of a chart with cells (by selecting a single label typing "=", clicking the cell to link with and then enter). Now I want to get the label's formula with VBA but I only get the value with objPoint.DataLabel.Text. I am missing something like objPoint.DataLabel.Formula. Currently I use XL 2003. Any good ideas? you need to activate(select) "the chart" AND activate(select) "the datalabel" and then... "ask" for help to the (ancient) xl-4 macro-functions (i.e.) msgbox executeexcel4macro("get.formula(selection())") which gives the formula in the form: =[bookname]sheetname!R1C1 or... you can "convert" into A1 notation i.e. msgbox application.convertformula(executeexcel4macro("get .formula(selection())"),xlr1c1,xla1) hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit row height when retrieving text via formula | Excel Discussion (Misc queries) | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
Where is a sample formula for retrieving the system date? | Excel Discussion (Misc queries) | |||
Using Name Label to try to define linked cell | Links and Linking in Excel | |||
Formula looks like a label | Excel Worksheet Functions |