Are Named Arguments not supported in VBA?

[JenniferMurphy]

I came across this page that explains Named Arguments.

Understanding named arguments and optional arguments (VBA)

Office VBA reference topic

learn.microsoft.com

But I can't get it to work. Here's the little test function I wrote:

Function TestArgs(p1, p2, p3)
Debug.Print Time & " p1 = '" & p1 & "', p2 = '" & p2 & "', p3 = '" & p3 & "'"
End Function

I tried calling it like this =testargs(p1:=1, p2:=2, p3:=3), but Excel takes p1, p2, & p3 to be cell addresses and it gets an error. I tried renaming the parameters to something that cannot be a cell address, but I got the same error.

Is this just a VB.Net feature?

 

[James006]

Hi,
Have you tested : =testargs(1, 2, 3)

 

[JenniferMurphy]

Hi,
Have you tested : =testargs(1, 2, 3)

That works, but it uses positional arguments not named arguments. I was hoping for a way to pass the arguments by name in any order.

 

[JenniferMurphy]

I think I found the answer. Apparently, this feature only works within VBA. If I call that test function from the Immediate window, it works:

(sigh)