Updating format of axis on the basis of a calculated value in a Cell

[maddison1984]

Hi All,

I'm new to this so please forgive my ignorance. I am trying to format a graph axis on the basis of the data in a cell which is calculated by formula.

To do this I have created one macro (which I have tested) which I intend to reference in the worksheet_calculate() function as below:


Private Sub Worksheet_Calculate()
If [A1] > 5 Then
Application.EnableEvents = False
Call Format_YAxis_Dollars
Application.EnableEvents = True
End If
End Sub

Can anyone help with this?

Thanks,
Matt

 

[Worf]

Hi and welcome to the Board

This worked for me:

Private Sub Worksheet_Calculate()


If [A1] > 5 Then
    Format_yaxis_dollars
    Application.EnableEvents = True
End If
End Sub


Sub Format_yaxis_dollars()
MsgBox "formatting is done here"
End Sub

 

[maddison1984]

Hi,

That worked great thank you.

Thanks,
Matt