Excel 2007 VBA UDF problem

snowman.hk · October 24th, 2009, 03:55 AM

Hi, i'm new to Excel VBA. I'm trying to create the same UDF as the centigrade to fahrenheit one. Tried to create a new one with same structure as the sample code, just different naming, but the result is zeros for every value of C. Could anyone help?

Code:

Function CtoF(degreeC)
    degreeCtoF = degreeC * 9 / 5 + 32
End Function

joe1946 · October 24th, 2009, 08:50 AM

The value has to be returned in a variable with the same name as the function itself, like this:

Code:

Function CtoF(degreeC)
    CtoF = degreeC * 9 / 5 + 32
End Function