VBA User Defined Function not working in Mac Excel 2016

Question

I wrote a user-defined function in Excel 2016 for Mac. The function itself works; I called it within VBA in a new Subroutine and it worked fine. But when I call it from the sheet, it does nothing.

    Function isMultipleOf5(myInput As Integer) As Boolean

    Dim result As Double

    result = myInput Mod 5

    If result = 0 Then
        isMultipleOf5 = True
    Else
        isMultipleOf5 = False
    End If

    End Function

Answer 1

It turns out I was placing the code under "Microsoft Excel Objects", and putting the code in ThisWorkbook or Sheet1 doesn't allow the function to work. Instead, you must right-click on Microsoft Excel Objects -> Insert -> Module -> place the code in the new blank area.