Optional Keyword (1 Viewer)

[doulostheou]

A friend of mine was trying to use the optional keyword in his function. I don't have any experience with it, so I was wondering if anyone could give him any advise on where he is going wrong. His syntax is something like below.

Function Test(x as Date, Optional y as Boolean)
If isMissing Then
....
ElseIf y = true Then
....
Else
....
End If

Apparently, isMissing never evaluates as true, even when he calls the function without a y variable.

Thanks in advance.

 

[Alexandre]

Only variants can (eventually) be evaluated to 'missing'. For other data types, you will have to define a default value and do some good old checking:

Function Test(x as Date, Optional y as Boolean = False)
If Not y Then ...

Or (less efficient, but if you really need to...)
Function Test(x as Date, Optional vary as Variant= False)
If isMissing(vary) Then ...

 

[doulostheou]

Thanks. That's exactly what he needed to know.