User Defined Function

[bnichol]

Is there a way that I can create a public function in the "Edit Modules" section, so that it can be called as an expression.

When I try this, I get the error "Bad function name" in the Edit Expression window.

Any suggestions?

B

[brenner_martina]

Hi,

did you name your macro? p.e. Sub MyFunction ... End Sub - you can enter Macros and use them in the script either or in the objects.

Otherwise you can enter function as a variable and use them like fields.

[bnichol]

I've defined the function like...

Public function test1(mbName)
...
test1 = false
end function

The function returns a boolean and I'm trying to use it in a Calculation Condition.