UDF help

[itselflearn]

Hi. I created my own UDF with the below code. Everytime I use the functions, like =Compare2Num(L5,N5), I get #NAME?. Can anybody help me pinpoint the issue? Thank you very much in advance.


Note : L5 and N5 can be decimal numbers like 1.8 and 0.779 respectively

Function Compare2Num(ByVal num1 As Variant, num2 As Variant) As String

If (num1 < num2) Then
    Compare2Num = "<"
ElseIf (num1 > num2) Then
    Compare2Num = ">"
Else
    Compare2Num = "="
End If

End Function

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[zbor]

#NAME indicates that function is not recognizable.
Did you copy your core into THAT workbook?

[MrShorty]

zbor. This looks like a duplicate thread, and the issue seems resolved: http://www.excelforum.com/excel-prog...ame-error.html

[zbor]

Thank you MrShorty!

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...ame-error.html

Thread Closed.