Optional in sub/functions(resolved)

[DiGiTaIErRoR]

Ok, when nothing is there it says Missing. What can I use in an if statement to check if it's not missing?

like:

sub DoSomething(optional var)
if var <> 'missing' then 'dosomething
end sub

[faisalkm]

use Ismissing

[faisalkm]

if ismissing(var) = true 'argument missing

[DiGiTaIErRoR]

The one thing I don't try.

Silly VB.

Thanks.

[Frans C]

Be aware that IsMissing can only be used for optional variant parameters.
Use default values for other parameter types.

eg.
sub DoSomething(optional aNumber as integer = -1)
if aNumber <> -1 then 'dosomething
end sub

[faisalkm]

thats a good hint Frans C