Quote Originally Posted by Hamond
Hi

...Running this is currently giving me a compile error: Expected function or variable.

Is it possible to do what I need with the approach I'm attempting or is there another way?

Many Thanks,

Hamond
Hi Hamond,

I am signing out, but just spotted your question and thought I'd give a quick stab at it.

Presuming you want the code to run only upon ticking the checkbox (not when clearing/un-ticking it, you'd want to check its value before proceeding. Also, I'm guessing that the choice is between Monthly and Quarterly, in which case you don't want the second IF nested in the first. Maybe:

Private Sub YoYDifference_Click()
 
    If Me.YoYDifference.Value Then
        If Monthly.Value Then
            Call Transform_Monthly_to_YoY_Difference
        ElseIf Quarterly.Value Then
            Call Transform_QTR_to_YoY_Difference
        End If
    End If
End Sub
I do not see what line in your present code would toss the error.

Hope that helps,

Mark