Named arguments [VBA snippet]

sub named_arguments(                          _
            optional a as string = "default", _
            optional b as string = "default", _
            optional c as string = "default")

  msgbox("a: " & a & ", b: " & b & ", c: " & c)

end sub


sub call_named_arguments

  named_arguments b:="passed argument"

  call named_arguments(c:="another value")

end sub