mbs function argument "is missing"

[rgandy]

all,
wondering if anyone knows how excel can capture a "missing" argument WITHOUT required a conditional ismissing function in the subsequent code

can the argument be defined in such a way as to catch missing arguments and provide them default values or at least make it so that the missing nature of the argument does not crap out the program?
thanks

 

[mp9]

You want syntax like this to make a parameter optional and specify a default value:

Sub MySub(Optional strVal As String = "defaultValue")
...
End Sub

http://www22.brinkster.com/accessory/

 

[TonyJollans]

Just typing optional arguments is enough to initialise them and stop them being "Missing". So

[blue]Function(Optional arg)
    If IsMissing(arg) Then [green]' Might be True[/green]
    :
    :[/blue]

but

[blue]Function(Optional arg as string)
    If IsMissing(arg) Then [green]' Will never be True[/green]
    :
    :[/blue]

It more-or-less works in the same way as Dimming variables - a Variant can be empty but a typed (non-object) variable is always initialised.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[