Overloading function calls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TobiasPC - 24 Jan 2007 23:58 GMT

I have some custom vba module procedures and I wanted to make some of the
parameters optional (by setting a default value) so that I could use
different signatures.

I was wondering if anyone could help out with and example of how you do it,
if it is possible.

Thanks

Reply to this Message

John Nurick - 25 Jan 2007 06:46 GMT

Optional parameters are easy:

Sub XXX(V As Long, _
Optional Q As Long = 99, _
Optional R As String = "Hello")

and you can even use named arguments if you like

XXX V:=123, R:="Goodbye"

See Help for the Sub and Function statements and IsMissing() function
for more.

>I have some custom vba module procedures and I wanted to make some of the
>parameters optional (by setting a default value) so that I could use
[quoted text clipped - 4 lines]
>
>Thanks

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message