Forum Discussion
Can't invoke a UDF from an excel sheet
I have office 365 and i can't invoke ANY user defined function.
For example - I have tried simple adding two numbers function.
Function add2numbers(x As Integer, y As Integer) As Integer
add2numbers = x + y
End Function after writing the above code, when i try calling that function in an excel sheet by `=add2numbers(3, 4)`
I get a pop up message saying: https://imgur.com/a/gt78eiT.
I have reinstalled complete office 365 but problem still persists.
Any leads? Thank you for your time.
Do you use comma as decimal separator? If so, use semicolons in the formula:
=add2numbers(3; 4)
2 Replies
Do you use comma as decimal separator? If so, use semicolons in the formula:
=add2numbers(3; 4)
Yes, Using SEMICOLON as a list separator RESOLVED the problem.
Due to my current regional settings, i was unaware that i was having Semicolon as List separator and i was constantly trying to invoke with comma.
Now, I have changed my regional settings, which has comma as a list separator.
I can now use COMMA to call a UDF.
Thank you very much for your time and assistance.
