Ok, now I better understand. You are setting up a user defined function.

Try the following code in a standard module
Function Convert(r As Range)
    Convert = r * 5
End Function
Then, test it in the spreadsheet. In cell A1, enter the number 10. In cell B1, enter the formula =CONVERT(A1)

Let me know if this is what you were after