Programming Excel with VBA and .NET

Name

ticklabels.Font

Synopsis

Returns a Font object you can use to format tick label text. For example, the following code makes the category axis tick labels italic:

Sub FormatTickLabels( )
    Dim chrt As Chart, ax As Axis, tl As TickLabels
    ' Get the chart.
    Set chrt = ActiveChart
    ' Get the category axis.
    Set ax = chrt.Axes(xlCategory, xlPrimary)
    ' Get the tick labels.
    Set tl = ax.TickLabels
    ' Format them.
    tl.Font.Italic = True
End Sub