NumberFormatLinked Property Example
This example links the number format for tick-mark labels to its cells for the value axis in Chart1.
Charts("Chart1").Axes(xlValue).TickLabels.NumberFormatLinked = True