Invalid Outside Procedure

I'm trying to create a new function that I'll be able to use within my spreadsheet.

Please Login or Register  to view this content.

When I try to use this function in the worksheet I get an "Invalid Outside Procedure" error and it highlights the first input x in the first line of code

Any ideas?

Where is the function stored? It should be in the Standard Modules and not the sheet module. Is this your case?

I think there is another fragment outside of that procedure that's causing the problem.

You could replace your UDF with

Please Login or Register  to view this content.

... or just a formula: =h * BINOMDIST(x, n, p, True)