Cannot use function with optional arguments

[Guest]

I have a function: Public Function fncTest(Optional A, Optional B)

In Source property of Text box I try: =fncTest(B:"xyz")
No good!

I try: =fncTest(A:="abc", B:"xyz")
No good!

I try: =fncTest("abc", "xyz")
Works fine.

Am I doing something wrong?

 

[Guest]

I have a function: Public Function fncTest(Optional A, Optional B)

In Source property of Text box I try: =fncTest(B:="xyz")
No good!

I try: =fncTest(A:="abc", B:="xyz")
No good!

I try: =fncTest("abc", "xyz")
Works fine.

Am I doing something wrong?

 

[Graham Mandeno]

Hi Tom

You can't use named arguments in a calculated expression - only in VBA.
However, you can use commas as place fillers for positional arguments:
=fncTest("abc")
=fncTest(, "def")